Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assignment problem
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assignment problem
Thanks Dave!! It was the second solution that I was looking for. Also, you are right about programming languages. Switching between them causes many a heartache! Utkarsh *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assignment problem
I think this is what you need as you first intended ...
Starting with a blank worksheet run this standard code: Sub test() Range("E1") = "Error 1" Range("E2") = "Error 2" For i = 1 To 2 Range("a" & i) = Range("E" & i) Next i End Sub HTH "Utkarsh Majmudar" wrote in message ... Thanks Dave!! It was the second solution that I was looking for. Also, you are right about programming languages. Switching between them causes many a heartache! Utkarsh *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |