View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Risky Dave Risky Dave is offline
external usenet poster
 
Posts: 161
Default 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