View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Better Use of Dim statement

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.

--
Regards,
Tom Ogilvy

"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