View Single Post
 
Old 04-11-2016, 11:22 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

IIRC an Excel aficionado named Ivan Moala developed such a utility about a decade ago. It would highlight the entire selected column & row, then restore the original formatting once you moved to another cell. IIRC there was a noticeable delay when changing cells, as the code had to: a) search the entire column & row for any existing highlights, so they could be saved; b) restore the highlight states for every cell in the exited row/column; c) re-save the highlights for any cell whose column/row overlapped the previous active cell's column/row; and, finally, apply the temporary highlights. Even that didn't try to preserve existing highlights while the column/row was 'active'. With modern workbooks having so many more rows & columns to handle, I wouldn't be surprised if the task became unmanageably slow.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote