Bright01
asked on
Need quick fix on defining a variable
EE Pros,
If you open the file I uploaded and hit the "Clear Data" button, you will find my error. I apparently have not declared a variable properly.
Help! Please.......
B.
Variable-Declare-Fix.xlsm
If you open the file I uploaded and hit the "Clear Data" button, you will find my error. I apparently have not declared a variable properly.
Help! Please.......
B.
Variable-Declare-Fix.xlsm
Its password protected...
and please add VBA in your topic, so others can also help you.
to declare
- a variable for number
dim variableName as long
dim variableName as integer
dim variableName as double
dim variableName as currency
- a string variable
dim variableName as string
- a date variable
dim variableName as date
- a variable for number
dim variableName as long
dim variableName as integer
dim variableName as double
dim variableName as currency
- a string variable
dim variableName as string
- a date variable
dim variableName as date
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Team, thank you!!! So sorry for the password problem. With a password like "password", I've already been contacted by the Democratic Party to see if I'd be their IT Security Specialist ;-)
Thanks Brad for the quick fix.
B.
Thanks Brad for the quick fix.
B.