Incidentally, the notes at the link indicate that the macro is slow, but it
works instantaneously for me....
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"Dave F" wrote:
See he http://www.mcgimpsey.com/excel/highlightrow.html
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"Mr. Low" wrote:
Dear Sir,
Can I have a light color bar at the active row to assist data entry under
Excel 2002 ?
Let consider the folowing worksheet:
A B C D E
1 A114 xxx
2 A126 xxx
________________________________
3 B135 xxx Light color bar --
________________________________
4 B246 xxx
5 C554 xxx
6 C412 xxx
7 D412 xxx
8 F411 xxx
9 G788 xxx
10 H891 xxx
11 J663 xxx
12 M258 xxx
Can I customized a light color bar to highlight row A3: C3 when I am doing
the data entry at cell C3 ?
This bar would move up and down as I move the cursor. It also lengthen or
shorten when the cursor is move right or left.
I need this sopecial feature could assist me to readi the content in each
cell in column A correctly before data is key in at several columns to its
left.
Thanks
Low
--
A36B58K641