View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Making a copying macro from cursor position ?

Jesper,
Do you mean cursor position or ActiveCell ?
How do you know A10 is the start on sheet2?
Assuming Sheet1 is your active sheet, a cursor position or activecell have
no meaning on Sheet2.

NickHK

"-[::::Shamran::::]-" wrote in message
...
How do I make a macro that is able to copy the content for the sheet 1 -
cursor position and 5 row wide: (fx. D5-D10) to sheet 2 and 5 coloms down
(fx. A10-F10) ? I am going nuts !

Jesper