Cannot convert from R1C1 reference to A1 reference even when options changed

dstepan

Board Regular
Joined
Apr 16, 2009
Messages
160
Hi everyone.

I don't understand why my VBA coding is still coming out with the R1C1 reference when I deselected it in my options.

I am using Excel 2016.

This system is supported remotely. Can that cause my options to be ignored?

I'm hoping somebody has maybe experienced the same issue and can help.

Thank you
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,181
Office Version
2007
Platform
Windows
Hi everyone.

I don't understand why my VBA coding is still coming out with the R1C1 reference when I deselected it in my options.

I am using Excel 2016.

This system is supported remotely. Can that cause my options to be ignored?

I'm hoping somebody has maybe experienced the same issue and can help.

Thank you

What do you mean with my VBA coding is still coming out with the R1C1

You can give some examples
 

Watch MrExcel Video

Forum statistics

Threads
1,102,344
Messages
5,486,310
Members
407,539
Latest member
ltwkuav

This Week's Hot Topics

Top