View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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