I have this code below. i want it to perform a task on project list
sheet while the button to execute the code is on another sheet, but its
executing the task on the same sheet the button is on, hence taking the
wrong data. what am i missing from the code?

Code:
--------------------
Sub smi()
'
' smi Macro
'
Range("A4:A" & Range("A3").End(xlDown).Row & ",D4:E" & Range("A3").End(xlDown).Row).Select
Selection.Copy
Sheets("Project List").Select
Range("A" & ((Range("A3").End(xlDown).Row) + 1)).Select
ActiveSheet.Paste

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


thanks

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