R1C1 reference
ActiveCell.FormulaR1C1 = _
"=IF(" & TagNmeMe.value & "!RC[-1]="""",""""," & TagNmeMe.value & "!RC[-1])"
--
Best Regards,
Luke M
"Rick" wrote in message
...
Can anyone tell me the proper structure for thid statement?
ActiveCell.FormulaR1C1 =
"=IF(TagNmeMe.value!RC[-1]="""","""",TagNmeMe.value!RC[-1])"
TagNmeMe is a string that has the stored Sheet Name .
if(sheet1!A5="","",sheet1!A5)
|