When using the Record Macro function, the "Relative Reference" button applies
the Active Cell command to the macro and achieves the desired results. Sorry
about not showing the macro, this is my first post on here and I was unaware
of the process.

Thanks for the help.

"Tim Williams" wrote:

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.