| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro copy function
I've installed the MSNStockQuote.functions add-in and set it to download the
"Open High Low Close" prices for XOM into cells M6:P6 I would like to create a macro that would automatically copy those values to the bottm of the data at columns M ~ P (paste special values only). Each day the columns grow one row longer. Any help would be marvelous - Thank you in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro copy function
See this page Nick
http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Nick Krill" wrote in message ... I've installed the MSNStockQuote.functions add-in and set it to download the "Open High Low Close" prices for XOM into cells M6:P6 I would like to create a macro that would automatically copy those values to the bottm of the data at columns M ~ P (paste special values only). Each day the columns grow one row longer. Any help would be marvelous - Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy name from active sheet to cell - using macro or function | Excel Worksheet Functions | |||
| macro to copy | Excel Discussion (Misc queries) | |||
| If than copy function / Macro | Excel Worksheet Functions | |||
| Copy a Macro | Excel Discussion (Misc queries) | |||
| Help with copy macro | Excel Discussion (Misc queries) | |||
Hybrid Mode
