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


"Chris Gorham" wrote in
message ...
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