View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr. Low[_3_] Mr. Low[_3_] is offline
external usenet poster
 
Posts: 19
Default Excel 2002; Macro for a light color band at the active row

Hi,

I find it difficult to read the cell content correctly at a distant column
of the same row.

For example to read the cell content of PQ 354 when the active cell is at
B354 when a large worksheet is open in a split window.

A B C D PQ PP
353 xxx T29
354 xxx K26
355 xxx U87

Is there any macro code for a light color band (light green or light yellow)
to turn on when I need it to serve as a "ruler" across an active row as I
move the cell up or down?

Appreciate very much if someone knowledgeable could help me on this.

Thanks

Low