' Macro1 Macro
This macro works except I need to be able to find a blank cell in column C.
The first time I run the Macro it works. The second time it copies over the
first entry not the cell below it. I am not sure how to change "Range(c9).
select"
Please see macro below

Thanks for the help

' Macro recorded 9/25/2006 by
'
' Keyboard Shortcut: Ctrl+a
'
Range("C1:G1").Select
Selection.Copy
'
Range("A1").Select
Selection.End(xlDown).Select
Range("C65536").Select
Selection.End(xlUp).Select
Range("C9").Select
ActiveSheet.Paste
End Sub

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200609/1