You can try creating a name;
While recording your macro go to INSERT-NAME-DEFINE- and place the cell
reference, make sure you do not use the $ Dollar sign, because it will fix
your cell reference.
Then record the rest of your macro.

"marwildfw" wrote:

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.