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.