"David494" wrote in
message ...

If anyone still knows how to do this then can you please let me know.

However, i figured out that i can just use "R2C1:R35C1" instead


Tools-Options-General and uncheck "R1C1" style box.