| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste a function using a Macro
I am using a master spreadsheet to collect data from several project
spreadsheets. Some of the older project spreadsheets are missing the most recent data cells, and I want to update the appropriate cells via a macro. after opening the old file from my master spreadsheet... Sheets("REPORTING").Select Range("B87") = "Abv from L4 Request" Range("D87") = "=L4_Request!Q44" The second cell ends up as text. I need it to work as a function. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro newbie - simple copy/paste function | Excel Programming | |||
| Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| Macro to Paste to specific line, and continue to Paste each time on next row not over | Excel Programming | |||
| Paste Function in Macro | Excel Programming | |||
Threaded Mode
