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.

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.

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.

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.