copy cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Narkom - 20 Mar 2006 19:09 GMT

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

Reply to this Message

Gary L Brown - 20 Mar 2006 22:56 GMT

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,

Signature

Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

> How do I copy the cells A9,B9,C9 and D9 to A16,B16,C16 and D16 when I
> press the key (F9) ? Afterwards I type new data in the cells A9 till D9
> and press again (F9), then I want that the stuff from A16 till D16 go to
> A17 till D17 and A9 till D9 again to A16 till D16.
> Sorry for my bad english and hope that anyone helps me.
> Thanks

Reply to this Message