copy cells

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
 
G

Gary L Brown

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,
 
Top