MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Problems adding formula to a cell


Posted by Christopher Patrick on September 13, 2001 11:04 AM

Hi all-

I am trying to enter the following lines into a script:

Sheets("Table of Contents").Select
Range("$A$3").Select
ActiveCell.FormulaR1C1 = "=('VTS Title Sheet'!$A$3)"

I basically want cell A3 of one sheet to be updated to the contents of cell A3 on another sheet. When I run the macro, the program fails. If I put a escape/backslash in front of the =, then the following prints:

/=('VTS Title Sheet'!$A$3)

Why can't I just enter the formula? Any hints?

Thanks for any help

Chris


Posted by Barrie Davidson on September 13, 2001 11:08 AM

Chris, try using

ActiveCell.Formula = "=('VTS Title Sheet'!$A$3)"

BarrieBarrie Davidson

Posted by Christopher Patrick on September 13, 2001 11:10 AM

Sorry all-

Just figured it out. I needed to use ActiveCell.Value to get what I was looking for

Take care

Chris