Better Use of Dim statement

  • Thread starter Thread starter Chris Gorham
  • Start date Start date
C

Chris Gorham

Hi,

I use Option Explicit in my code as best practise -
however I end up with large numbers of lines of Dim
statement for my variables...

Dim sht_cont_temp1 As String, Sht_name As String,
sht_name1 As String, etc etc

is it possible to group all of the above variables
something like...

Dim (sht_cont_temp1, Sht_name, sht_name1) As String

what do the pro's do...??

Thks...Chris
 
that syntax is not supported.

You have shown the method that is supported. There are some remnants from
Basic that allow the use of symbols and implicit type declarations, but I
don't believe the "pros" use these.
 
Chris,

Unless you are declaring Variant type variables, you need an As
Type clause for each variable. There are no shortcuts for
declaring several variables to be the same type (other than the
DefType statement). I tend to use the longest syntax of one Dim
statement on one line for each variable.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You can't do what you are suggesting from VBA.
In VB.NET, this is the way variables are declared.
 
Back
Top