| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Paste a function using a Macro
Range("D87") = "=L4_Request!Q44"
Range("D87") .FORMULA= "=L4_Request!Q44" -- Don Guillett Microsoft MVP Excel SalesAid Software "Chris T-M" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Paste a function using a Macro
Thanks Don, but I still get the function as Text. Is there any chance some
other part of my code could be effecting this? (I tried the .FORMULA=) "Don Guillett" wrote: Range("D87") = "=L4_Request!Q44" Range("D87") .FORMULA= "=L4_Request!Q44" -- Don Guillett Microsoft MVP Excel SalesAid Software "Chris T-M" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Paste a function using a Macro
Very possible that you have pre-formatted the cell as text.
Re-format to General and try again. Gord Dibben MS Excel MVP On Fri, 1 Feb 2008 14:58:16 -0800, Chris T-M wrote: Thanks Don, but I still get the function as Text. Is there any chance some other part of my code could be effecting this? (I tried the .FORMULA=) "Don Guillett" wrote: Range("D87") = "=L4_Request!Q44" Range("D87") .FORMULA= "=L4_Request!Q44" -- Don Guillett Microsoft MVP Excel SalesAid Software "Chris T-M" wrote in message ... 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. |
| Reply |
| 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 | |||
Hybrid Mode
