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

activecell.entirerow.select

Dunca

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

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

Michael wrote in message
...
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