View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kjeldc[_3_] Kjeldc[_3_] is offline
external usenet poster
 
Posts: 12
Default Copy range with offset

I know how to copy a cell like this:

..Offset(-1, 13).Select
Selection.Copy
.Offset(0, 13).Select
ActiveSheet.Past-

But how can I copy a range like this


..Offset(-1, 13-21).Select
Selection.Copy
.Offset(0, 13).Select
ActiveSheet.Paste


My programming is self-taught and
my teacher was not very experienced. :-)

cheers,
Kjeld