Difference Between Range("SelectedRange").Value and ActiveCell
Thanx anyway, Im used to pascal where you have to convert everthing between
types
"Dave Peterson" wrote:
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
|