Thread
:
Set Multiple Variables
View Single Post
#
3
Posted to microsoft.public.excel.programming
Nigel[_3_]
external usenet poster
Posts: 31
Set Multiple Variables
You can dim multiple variables on one line
Dim sText1 as String, sText2 as String
or why not consider using an array e.g
Dim sText(1 To 20) As String
You can then set and read each by reference the array index
sText(1) = "My Value"
--
Regards,
Nigel
"Risky Dave" wrote in message
...
Hi,
If I have Dim'd a bunch of string variables, is it possible to set them
all
to the same value in a single line?
Eg.
Dim sText1
Dim sText2
sText1, sText2 = "" 'this doesn't work!
I actually have about 20 of these variables that I want to set to blank
before working with them, and having the same line 20 times seems to be
rather inefficient.
This is in Office 2003, if that makes a difference.
TIA
Dave
Reply With Quote
Nigel[_3_]
View Public Profile
Find all posts by Nigel[_3_]