Excel/VBA is pretty nice:

Instead of this:
Range("A" & CStr(i)).Value
you could use:
Range("A" & i).Value
or
cells(i,"A").Value

(Yeah, I know you didn't ask.)


James Barrass wrote:

Tried Range("A" & CStr(i)).Value to dynamically change the range, only worked
when i was a constant

--

Dave Peterson