View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
James Barrass James Barrass is offline
external usenet poster
 
Posts: 3
Default 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