Formula Problem in macro
I've tried a number of variation on your idea and each one produces a 400
error.
"Barb Reinhardt" wrote:
You have:
Range("A5").FormulaR1C1 = "=IF('Executive Phone
List.xls'!A5="","",'Executive Phone List.xls'!A5)
You probably want something like this to reference A5
=Sheet1!A5 (if in the same workbook or
=[MyBook.xls]Sheet1!A5
if in another workbook
HTH,
Barb Reinhardt
If this post was helpful to you, please click YES below.
"Stephen" wrote:
Hi Folks,
This seems strange to me... I have a formula which works fine...
=IF('Executive Phone List.xls'!A5="","",'Executive Phone List.xls'!A5)
but when I try to insert that via a macro I get an error.
Range("A5").Select
ActiveCell.FormulaR1C1 = "=IF('Executive Phone List.xls'!A5="","",'Executive
Phone List.xls'!A5)"
Produces:
#NAME?
TIA,
Steve
|