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...
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...
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...
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...