Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 reference
Luke the compiler did not like that code format ...
"Rick" wrote: 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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 reference
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. Rick wrote: 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) -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 reference
Thank Dave it work like a charm
"Dave Peterson" wrote: 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. Rick wrote: 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) -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
R1C1 Reference Style Default | Excel Discussion (Misc queries) | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
R1C1 Reference Style won't STAY gone? | Excel Discussion (Misc queries) | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
R1C1 reference | Excel Discussion (Misc queries) |