Worksheets("sheet1").Cells(CountA, 1).EntireRow.Copy _
Worksheets("sheet3").Cells(CountA, 1)


"smitty24" wrote:

I have an IF statement that compares a particular cell in two different
worksheets.

If Worksheets("sheet1").Cells(CountA, 1) =
Worksheets("sheet2").Cells(CountB, 1)

If my statement is true, how do I copy the entire row in which
cells(CountA,1) resides in on "sheet1" to a new worksheet "sheet3" in the row
that (CountA,1) is located on?

Thanks!