hi,

I am trying to put together a simple macro to do the following job - so
far I haven't succeeded:

copy active cell value,go to the first worksheet in my spreadsheet,
find the pasted value in there and select the row where it has found
the value.

can anyone help?

Thx.

Tom