Hi

I'm hoping to get some help in writing a macro to do the following:

Copy data that is in active cell on active sheet
Go to first empty cell in range D9:D729 of Sheet2
Paste the value only
Drop down one row
Insert one row
End

Any help is greatly appreciated.
Thank

--
Message posted from http://www.ExcelForum.com