Thread: Dynamic Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Arnie Arnie is offline
external usenet poster
 
Posts: 65
Default Dynamic Range

I have a dynamic range which i use

Range("A3").End(xlDown).Offset(-1, 0).Select

to find the last cell with data in.

Then i use ActiveCell.Resize(1, 12).Select to select across to column L

What i can't seem to do is select up from ActiveCell in this case A363 (this
is dynamic) to L363 to A3:L3 (this range is then required to be copied)

Any help would be appreciated

Thanks in advance

Arnie