"don" wrote
Thanks Max.
You're welcome !

When i tried the code it kept bringing me back to the
same 1st worksheet in which I highlighted the row.

Sorry, got to leave this to Don G. or others versed in vba to respond
further to you. Believe it's presumed that the sheets are identically
structured as far as the names are concerned, e.g. Name13 will appear in say
row13 on *every* sheet, and that you'll start the name/row selection in
*Sheet1*
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----