View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
smitty24 smitty24 is offline
external usenet poster
 
Posts: 3
Default Copying an entire row

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!