By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,057 Members | 1,407 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,057 IT Pros & Developers. It's quick & easy.

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

P: 2
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").Copy
rANGE("C12").Select
ActiveSheet.Paste


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?
Dec 14 '07 #1
Share this Question
Share on Google+
2 Replies


QVeen72
Expert 100+
P: 1,445
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
Dec 14 '07 #2

P: 2
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
Dec 16 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.