Hello,
I am trying to create a macro in which I can copy an entire row fro
one sheet and paste it to the bottom of another sheet. (and some othe
things within the macro)

I am stuck on two pieces. First, I would like to select the entire ro
in which the user has their curser in. Second, I can not figure ou
how to paste it to the bottom (next blank row) of the other sheet.
Here is my macro so far:

Sub NotMeetCriteria()
Rows("3:3").Select <-How do I select entire row?
Selection.Copy
Sheets("Did Not Meet Hiring Criteria").Select
Rows("28:28").Select <- How do I paste to bottom of sheet?
ActiveSheet.Paste
Sheets("1-OPEN").Select
Range("H3:P3").Select
Application.CutCopyMode = False
Selection.ClearContents
ActiveWindow.SmallScroll ToRight:=-4
Range("A3").Select
Sheets("Did Not Meet Hiring Criteria").Select
Range("L28").Select
ActiveWindow.SmallScroll ToRight:=2
End Sub

Help...thanks!
Mik

--
Message posted from http://www.ExcelForum.com