declaration is too long

[Agnes]

Sorry for my silly question. I need to declare may variable as string.
1st line dim x,y,a,_
2nd line b,c,d as string
(it seems syntax error, Please be kind to correct me)

 

[Shiva]

Hi,
Leave a space between ',' and '_' on the 1st line as in

Dim x,y,a, _
b,c,d as string

Sorry for my silly question. I need to declare may variable as string.
1st line dim x,y,a,_
2nd line b,c,d as string
(it seems syntax error, Please be kind to correct me)

 

[Agnes]

;O thanks a lot

 

[Jay B. Harlow [MVP - Outlook]]

Agnes,
I would suggest:

1st line dim x,y,a As String
2nd line Dim b,c,d as string

However I normally use:

Dim x As string
Dim y as string
Dim a as string
Dim b as string
Dim c as string
Dim d as string

With that many variables, I would look at what the routine was really doing
and refactor (http://www.refactoring.com) so I did not need so many string
variables. Such as using an Array instead.

Hope this helps
Jay