View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
BobC BobC is offline
external usenet poster
 
Posts: 11
Default Cell References absolute?

Jarek,

Go it to to work!!

Fantastic - many thanks

Bob

"Jarek Kujawa" wrote:

use:

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