View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default Cell References absolute?

use:

Sub kopying()
Selection.Copy
ActiveCell.Offset(3, 0).Select
ActiveSheet.Paste
End Sub