A possible, and possibly better alternative to suit your underlying motives.
Try Autofilter? Apply it via DataFilterAutofilter.
Then choose the value, eg: 1
from the particular col's autofilter droplist
to easily filter out all lines with that value
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"Jon" wrote:
Is there any way to highlight the related cells for selected cell in list?
For example if I select cell has 1 , all cells have the value 1 will be
highlight automatically?
Any help please?