View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Gorham[_3_] Chris Gorham[_3_] is offline
external usenet poster
 
Posts: 31
Default Better Use of Dim statement

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