Recent content by markwilliams12

Is anyone else having issues getting updated stock information from the MSN Stock Quotes? (looked for other threads on this topic, but didn't find any.) I've got a handful of ticker symbols that are still returning updated share value after markets close, but it is returning that same value for...

Yeah, the way I'm attempting to do it is by no means efficient. And I do have some concerns about how long it will take Excel to crash if all cells are selected. :) I wasn't aware VBA could script an undo/redo. I'll have to play with your idea a bit.

Thanks! I'm using the Workbook_SheetSelectionChange to capture when a cell was changed. I'll be expanding that to capture values of the range selected to an array. The calling of my LogChange Module is done via Workbook_SheetChange. So throw in a couple of loops and I can log range changes of...

I have a UDF that logs actions in one of my excel sheets. It works great, except that it isn't aware when I (or another user) copies and pastes a range of cells to another range of cells. I would have hoped that MS would have included a AfterPaste Worksheet Event, but this doesn't exist...

@Mike86 - Thanks for the reminder to used Name Ranges. Can't believe I forgot about that option! @NARAYANK991 - I used your part 2 Very nice formula! Works great! Thank you both.

Here's the data: 6/1/2009 $7,623.21 6/2/2009 $7,619.67 6/3/2009 $7,616.75 6/4/2009 $7,531.05 6/6/2009 $7,514.32 6/7/2009 $7,514.32 6/8/2009 $7,514.32 6/9/2009 $7,511.09 6/10/2009 $7,421.73 6/11/2009 $7,368.50 6/12/2009 $8,040.21 6/13/2009 $8,034.51 6/14/2009 $8,034.51...

I am wanting to chart some data, that is pretty simple to do manually, but I'm interested in how to setup the series dynamically. The data is 2 columns. Column 1 - Date Column 2 - Amount Data is entered daily. It currently covers 6/1/2009 to today. I would like to create series that...

Thanks to you all, that did the trick!

The purpose of my tracking doesn't matter. If you find moon phases bizarre, then consider that my function returns the numbers 1 through 8. Just looking for a way to chart Numeric data returned from a UDF. Any thoughts?

I'm tracking my weight and to extend my excel knowledge decided to track Moon Phase as well to see if there is any impact to my weight. I've got a UDF that I use to determine Moon Phase as shown here: Public Function MoonPhaseNumber(InputDate) MoonYear = Year(InputDate) MoonMonth =...

I have several tables of data with corresponding charts. The tables grow to several hundred rows and if I want to view the chart with this data, it is currently located at the top of the worksheet. Is there any trick that I'm missing that would allow me to pin, anchor or otherwise tie the...