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