Showing your macro would help a lot...

Absent that, try working with "ActiveCell" or "Selection"

--
Tim Williams
Palo Alto, CA


"marwildfw" wrote in message ...
I want to use the search function to find specific data and then use a macro
to select the entire row and transpose it into a column and then print the
data.

The macro works but it selects the same row every time. I want to know how
to tell the macro to start in the current cell.

I use the record function to create the macro, so a simple solution would be
appreciated.