Thread: R1C1 reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rick Rick is offline
external usenet poster
  
Posts: 334
Default R1C1 reference
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)


Reply With QuoteReply With Quote