Results 1 to 5 of 5

Thread: Heres Something Strange
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Oct 2003
    Location
    Texas
    Posts
    155
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Heres Something Strange

    So I'm working along and all of a sudden the key word Range is now replaced with range (lower case). When I type the word the first letter is capitalized, but when I complete the line and move on the capital R goes to lower case. I don't know where I could have changed a reserved word.

    I'm certain my machine is possessed.

    Any idea where I made the change? I have not defined any variable as Range or range.
    I'm right everytime I'm not wrong!

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    74,979
    Post Thanks / Like
    Mentioned
    59 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Heres Something Strange

    Did you call anything 'range'?

    And I mean anything - variable, module, sub, function...

    Also do you have any add-ins installed?
    If posting code please use code tags.

  3. #3
    Board Regular
    Join Date
    Sep 2005
    Posts
    5,065
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Heres Something Strange

    Look here:

    http://www.mrexcel.com/forum/excel-q...pitalized.html


    Quote Originally Posted by Andrew Poulsom View Post
    The only way I can replicate that behaviour is if I have at some time dimensioned a variable named "range". Then, even if I delete the Dim statement, Range is still uncapitalized.

    The solution is to temporarily insert:

    Dim Range

    so that the occurrences are capitalized, and then delete it.

  4. #4
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,100
    Post Thanks / Like
    Mentioned
    41 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Heres Something Strange

    Hi,

    Your computer is probably not possessed, unless: The Top 11 Signs Your Computer is Possessed
    Last edited by jtakw; May 18th, 2016 at 04:43 PM.

  5. #5
    Board Regular
    Join Date
    Oct 2003
    Location
    Texas
    Posts
    155
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Heres Something Strange

    Excellent, Sheetspread! I have exorcised the demon!
    Nori - I had a sheet named "Ranges." Not Range. I renamed it to NamedRanges. Now that I am done with it I have deleted it. I did the Dim Range and everything went back to normal. I may have typed Dim Range somewhere along the way and then said "Hey, idiot, you can't use Range there!" Then deleted it and corrected the bone head error. I don't remember doing that, but it is possible.

    Anyway, all is back to bliss.

    Thank you so much for your replies.
    I'm right everytime I'm not wrong!

Some videos you may like

User Tag List

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
  •