Hi,

I stumbled upon what I think is a pretty bizarre issue today and I was wondering if anyone can shed some light on it.

If I have the formula =CELL("address",B2) in cell B2, it correctly returns "$B$2". However, if I use R1C1 notation in ANY cell in a macro, B2 suddenly returns "R2B2" rather than "$B$2". If you enter the formula in B2 and then run this simple sub you can see what I mean. Interestingly,
the address will change back to "$B$2" when you uncomment the line Application.Calculate, even though I have Calculation Options set to Automatic before and after running the sub. I realized this because it is affecting some conditional formatting I have that requires the Indirect and Cell("address") functions. Obviously application.calculate would be a workaround but I would prefer to know why this is happening as well.

Please Login or Register  to view this content.