View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] utkarshm@hotmail.com is offline
external usenet poster
 
Posts: 2
Default Assignment problem

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