ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Variables in VBA (https://www.excelbanter.com/excel-discussion-misc-queries/114740-variables-vba.html)

Jeff

Variables in VBA
 
Hi,

I think that excel has some restrictions on variable names. Some names it
has predefined and you can't use these names as variables. I was getting
weird errors when I use a variabl name = "Rate". Is there a list of the
restricted variable names?

Thanks for your help.


Gary''s Student

Variables in VBA
 
Rate is a pre-defined function in VBA. For a list of VBA functions, use VBA
Help
--
Gary''s Student


"Jeff" wrote:

Hi,

I think that excel has some restrictions on variable names. Some names it
has predefined and you can't use these names as variables. I was getting
weird errors when I use a variabl name = "Rate". Is there a list of the
restricted variable names?

Thanks for your help.


Don Guillett

Variables in VBA
 
use MYrate

--
Don Guillett
SalesAid Software

"Gary''s Student" wrote in message
...
Rate is a pre-defined function in VBA. For a list of VBA functions, use
VBA
Help
--
Gary''s Student


"Jeff" wrote:

Hi,

I think that excel has some restrictions on variable names. Some names
it
has predefined and you can't use these names as variables. I was getting
weird errors when I use a variabl name = "Rate". Is there a list of the
restricted variable names?

Thanks for your help.





All times are GMT +1. The time now is 10:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com