This is too easy to post here but I need help...
Posted by Bill Tanner on February 07, 2002 6:51 PM
Cell Range (Worksheet 1) C49:H49 value is "1567"
VBA Code sez:
If Sheets("Worksheet 1").Range("C49:H49").Value <> "" Then
ActiveCell.FormulaR1C1 = "='Worksheet 1'!C49:H49"
The Code inserts the correct formula but I'm getting a #NAME? and I can't seem to figure out why. I've messed with formatting of the two cells -- trying various combinations of General and Text but other than occassionally changing to a #VALUE error message, I can't seem to make it work.
So what am I doing wrong here?
Thanks in advance.