Wow...pasting that code was really great.
How would you make that into a macro to run whenever you want?

"CLR" wrote:

ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that does this nicely.....

Vaya con Dios,
Chuck, CABGx3



"suesolotel" wrote:

hi when i am checking data entry in a spreadsheet with a lot of information i
am having trouble keeping my on the row i am reading - is there a way you can
set the rows to shade in grey or similar so as you arrow down your eye is
always drawn to the current row you are reading?