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!