Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Multiple Variables
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Multiple Variables
Hi,
You can't reset a group of individual variables in one go, it would have to be done one at a time. Mike "Risky Dave" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Multiple Variables
Darn! (or words to that effect)
Thanks anyway "Mike H" wrote: Hi, You can't reset a group of individual variables in one go, it would have to be done one at a time. Mike "Risky Dave" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Variables | Excel Programming | |||
how can i count multiple variables in multiple columns? | Excel Programming | |||
Multiple variables-SOS | Excel Worksheet Functions | |||
look for a value with multiple variables | Excel Discussion (Misc queries) | |||
Multiple variables | Excel Programming |