Paste a function using a Macro

C

Chris T-M

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.
 
C

Chris T-M

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=)
 
G

Gord Dibben

Very possible that you have pre-formatted the cell as text.

Re-format to General and try again.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Combine Data from Multiple Sheets with Cell References 4
Extend a Range 2
Adding a date timestamp to the last column of a spreadsheet 6
Copying data from several spreadsheets into a new spreadsheet 2
Paste Range to a new workbook 4
Macro to combine worksheets 10
Store cell & workbook references, to retrieve later in Macro 3
Pasting cell contents into a macro 1

Top