In the previous version of Excel for OSX I had many scripts where I used the simple notation of :
Insert Column “E”, and
set rangevariable to (“R” & (loopcount as string) & “C2”), and
set FormulaR1C1 of ActiveCell to loopcount
this notation is broken upon upgrading to Excel 2004, and I cannot make sense out of the dictionary for figuring out the reason why my old scripts cannot reference cells and ranges. Does anyone know how Excel now likes cells referenced?
Thanks for your time