Cannot convert from R1C1 reference to A1 reference even when options changed
Results 1 to 4 of 4

Thread: Cannot convert from R1C1 reference to A1 reference even when options changed
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2009
    Location
    NE USA
    Posts
    160
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,732
    Post Thanks / Like
    Mentioned
    65 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Cannot convert from R1C1 reference to A1 reference even when options changed

    Quote Originally Posted by dstepan View Post
    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
    Regards Dante Amor

  3. #3
    Board Regular
    Join Date
    Apr 2009
    Location
    NE USA
    Posts
    160
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot convert from R1C1 reference to A1 reference even when options changed

    Thank you for responding but it is now working.

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,732
    Post Thanks / Like
    Mentioned
    65 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Cannot convert from R1C1 reference to A1 reference even when options changed

    Quote Originally Posted by dstepan View Post
    Thank you for responding but it is now working.
    I'm glad that it works for you.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •