Using a macro to copy current row to another sheet

Hello,

Macro rookie here...

I am trying to make a macro that will select the current row that the cursor is on in sheet 1, copy it, and paste it on sheet 2.

For some reason when I do this and then run the macro, it is copying the an absolute row from the first sheet and copying it to the second sheet...It is not selecting the row that the cursor is on...Any ideas???

Thanks for the hand...

Mike

How come there is no answer to this simple question?? I am sitting here not knowing if no one is interested in helping out, of if I posted this request incorrect??

Hmmmmm