Posted to microsoft.public.excel.programming
|
|
Assignment problem
You probably meant
Range("a" & i) = E(1)
should be
Range("a" & i) = E(i)
--
Regards,
Tom Ogilvy
"Dave Peterson" wrote in message
...
You could just do this:
Sub test()
For i = 1 To 2
Range("a" & i) = "Error " & i
Next i
End Sub
But I think you're trying to do this:
Sub test2()
Dim i As Long
Dim E(1 To 2) As String
E(1) = "Error 1"
E(2) = "Error 2"
For i = 1 To 2
Range("a" & i) = E(1)
Next i
End Sub
VBA won't allow you to build variable names on the fly (like some other
languages) like you originally wanted.
wrote:
I would like cells A1, A2 etc to populate with "Error 1", "Error 2"
etc. However when I use this:
Sub test()
E1 = "Error 1"
E2 = "Error 2"
For i = 1 To 2
Range("a" & i) = "E" & i
Next i
End Sub
I get "E1", "E2 as a result. I know I am making a silly goof and help
would be greatly appreciated.
Thanks
Utkarsh
--
Dave Peterson
|