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

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

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!

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

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!