VB Code - Word "Range" changed case to "rANGE"

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RONSCHERER
    New Member
    • Dec 2007
    • 2

    VB Code - Word "Range" changed case to "rANGE"

    Hi. I write in VB. For some strange reason, throughout all the code written in one of my workbooks, the word "Range" had simply changed its case to "rANGE".

    eg:
    rANGE("C11").Co py
    rANGE("C12").Se lect
    ActiveSheet.Pas te


    The following may be relevant:
    - Only the word "Range" has changed its case
    - It has not happened in any of the other workbooks I have created.
    - It has not affected the functionality of the code in any way.

    Anybody have any ideas what may have caused this?
  • QVeen72
    Recognized Expert Top Contributor
    • Oct 2006
    • 1445

    #2
    Hi,

    Check whether you have Declared any variable with name "rANGE"

    You might have declared in the Same procedure or Form Level or Public variable in the Module.

    Regards
    Veena

    Comment

    • RONSCHERER
      New Member
      • Dec 2007
      • 2

      #3
      Hi Veena,

      Thanks for your response. I have checked your recommendation and it does not appear to be the cause. I have checked all Private and Public Functions (there are only 2 in the workbook - although the workbook is very large), but there are no references to rANGE in those functions. All other code is emodied within Macros.

      Any other suggestions will be appreciated.

      Thanks a mill.

      Ron

      Comment

      Working...