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

[dstepan]

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

 

[DanteAmor]

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

 

[dstepan]

Thank you for responding but it is now working.

 

[DanteAmor]

Thank you for responding but it is now working.

I'm glad that it works for you.