R1C1 reference

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

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)
 
ActiveCell.FormulaR1C1 = _
"=IF(" & TagNmeMe.value & "!RC[-1]="""",""""," & TagNmeMe.value & "!RC[-1])"
 
If tagnmeme is really a string, then it doesn't have any properties (like
..value).

ActiveCell.FormulaR1C1 _
= "=IF('" & TagNmeMe & "'!RC[-1]="""",""""," & "'" & TagNmeMe & "'!RC[-1])"

Sometimes, the sheet name has to be surrounded by apostrophes (if the sheet name
in a number or looks like an address or contains spaces or ...).

If you supply them and they aren't needed, excel won't care. But if you don't
supply them and you do need them, excel will yell.


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)
Click to expand...
 
Thank Dave it work like a charm

Dave Peterson said:
If tagnmeme is really a string, then it doesn't have any properties (like
..value).

ActiveCell.FormulaR1C1 _
= "=IF('" & TagNmeMe & "'!RC[-1]="""",""""," & "'" & TagNmeMe & "'!RC[-1])"

Sometimes, the sheet name has to be surrounded by apostrophes (if the sheet name
in a number or looks like an address or contains spaces or ...).

If you supply them and they aren't needed, excel won't care. But if you don't
supply them and you do need them, excel will yell.


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)
Click to expand...
Click to expand...
 
Back
Top