The "current cell" changes after each search because the critera is different
for each search. Naming would always point to the same cell. I found that
the "relative reference" button in the record macro box attaches the start of
the macro to the current cell.

Thanks for your help.



"Michael" wrote:

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.