copy cells

  • Thread starter Thread starter Narkom
  • Start date Start date
N

Narkom

How do I copy the cells A9,B9,C9 and D9 to A16,B16,C16 and D16 when
press the key (F9) ? Afterwards I type new data in the cells A9 till D
and press again (F9), then I want that the stuff from A16 till D16 go t
A17 till D17 and A9 till D9 again to A16 till D16.
Sorry for my bad english and hope that anyone helps me.
Thank
 
Start out by assigning F9 to your macro. Probably in the Workbook_Open
procedure.

Application.OnKey "{F9}", "MyMacro"

Then have a macro called 'MyMacro' or whatever that does this...

Range("A16").EntireRow.Insert
Range("A9:D9").Copy
Range("A16").PasteSpecial xlValues
Application.CutCopyMode = False
Range("A9").Select


Hope this helps,
 
Back
Top