Excel Type Code

[B Wilcox]

Hello,

A data type code is automatically changing to lower case
rather then the usual upper case.

Dim XX as Range appears as Dim XX as range

How can I correct?

B Wilcox

 

[Rob Bovey]

This means that you declared a variable with the name "range" somewhere
in your code. The first thing you need to do is find and delete that
declaration. Then add the following variable declaration at the top of a
code module:

Public Range As Variant

Choose Debug/Compile from the VBE menu and then delete this variable
declaration. In general you should never declare variables that have the
same name as Excel objects, properties or methods.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[Tom Ogilvy]

have you declared a variable with a name of range

possibly a typo.