Help includes all of the functions and statements. To check on a single word,
you could type it in lower case in the immediate window. It VBA changes the
capitalization, it's a reserved word. Also, type the word, and with the cursor
to the immediate right of it, press F1 for Help.


On Tue, 31 Aug 2004 07:09:03 -0700, Spikey
wrote:

Does anyone know if there is a list of reserved words that one cannot use in
Excel VBA code such as 'Split' which is now a function

Many thanks for that. I am working on a data conversion exercise 2000 to XP
and am looking for an actual list of reserved words which i cannot find in
either help or the Microsoft website. Does such a list exist or is it just a
case of trial and error.

"Myrna Larson" wrote:

Help includes all of the functions and statements. To check on a single word,
you could type it in lower case in the immediate window. It VBA changes the
capitalization, it's a reserved word. Also, type the word, and with the cursor
to the immediate right of it, press F1 for Help.


On Tue, 31 Aug 2004 07:09:03 -0700, Spikey
wrote:

Does anyone know if there is a list of reserved words that one cannot use in
Excel VBA code such as 'Split' which is now a function