followed your advice.

This is the code I have
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/31/2008 by Darrell.Sarrasin
'

'
Range("G2:G101").Select
Selection.Copy
Sheets("TTU Completions").Select
Range("A2").Select
ActiveSheet.Paste
End Sub

when I run it the line of Range("A2").Select comes back as an error.
Bob I wrote:
Record a macro that selects the cell, copies it, selects destination
cell, pastes it.

hehe that is the easiest, but its a complicated set up where I want a lot to
be automated. I have a bout 10 users and they want it as simple as possible.
[quoted text clipped - 10 lines]
read
it if htat makes sense. any help is appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200810/1