Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Picture # assignment | Excel Discussion (Misc queries) | |||
Number Assignment | Excel Worksheet Functions | |||
Key Assignment Log | Excel Discussion (Misc queries) | |||
assignment problem | Excel Worksheet Functions | |||
Assignment Statement | Excel Programming |