thanks

im not really a competant coder, i replaced what i had with what you
said but it does not work, is it the wrong order?


Code:
--------------------
Sub smi()
'
' smi Macro
' Macro recorded 26/05/2006 by jharri4
'

'
Range("A4:A" & Range("A3").End(xlDown).Row & ",D4:E" & Range("A3").End(xlDown).Row).Select
Selection.Copy
Sheets("SMI Project List").Select
Range("A" & ((Range("A3").End(xlDown).Row) + 1)).Select
Sheets("SMI Indicators").Range("A4:A" & Range("A3").End(xlDown).Row & ",D4:E" & Range("A3")).Copy
Sheets("SMI Project List").Range("A4:A" & Range("A3").End(xlDown).Row & ",D4:E" & Range("A3")).Paste

End Sub
--------------------


it was saying there is a problem with line 5, the copy line...

Jamie


--
jay d
------------------------------------------------------------------------
jay d's Profile: http://www.excelforum.com/member.php...o&userid=34487
View this thread: http://www.excelforum.com/showthread...hreadid=548522