Row reference

[Michael]

I am trying to copy a row from a subtotal table to another
sheet. I can select the cell that starts the row with
find but do not know how to select the entire row in a
macro. Any help would be appreciated.

Thanks

 

[DNF Karran]

activecell.entirerow.select

Dunca

 

[Martin]

Michael,

Try:

Range("a1").EntireRow.Select

if that doesn't fit because you will be copying 256 columns of one row, (Run
Time error 1004), then restrict what you copy to the cells that are
populated and try (all one line) :

Range([a1], ([iv1].End(xlToLeft))).Copy Destination:=Sheets(2).[a1]

Martin