I have some global variables declared and want to access them in subrorutines using the For statement.
For example, I want to use the following to place values in the global variables , i.e, dblcell1, dblcell2, dblcell3, etc.
Dim m As Integer
For m = 3 To 11
If e.Row.Cells(m).Text <> " " Then
dblCell & m = e.row.cells(m).text)
End If
Next
I know that I can't use the "dblCell & M". It is just to show the objective. It is where I get an error.
Thanks
View Complete Post