!RC is used in the above code example. I needed to use it in order to append "X11" to the end of the string. Simply putting X11 in quotes didn't work. This example is embedded within code that causes X11 in each sheet to refer to the X11 cell in the previous sheet.
I've seen other examples of using !RC that look like the following: !R[4]C and !R24C20. However I cannot find an explanation for its usage or meaning anywhere. I need to know how flexible its usage is and what syntax is involved.
Thanks
Dennis