MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help; I need a way to highlight across columns in a single row.


Posted by Dave W on September 27, 2001 9:13 PM

Is there a way to highlight data in a row across several columns. Much like having a ruler that moves down each row with the cursor. I have several spreadsheet that have lots of colums and it is difficult seeing across the entire row without moving the cursor. It would be great if I could turn on a a macro that would highlight the entire row across all the colums similar to when you click on the row number, but being allowed to do it from any column and be able to scroll with it.


Posted by Ian on September 27, 2001 10:19 PM

Have a look at "Highlight.zip" at :-
http://geocities.com/aaronblood/pages/vba.html


Posted by Dave W on October 01, 2001 5:08 AM

THAT IS EXACTLY WHAT IS NEED. SO HOW DO I GET IT TO WORK IN THE SPREADSHEET I NEED IT TO WORK IN. IT ONLY SEEMS TO WORK IN THE EXAMPLE.


Posted by Anon on October 02, 2001 4:59 PM

re

Just copy the macro from the example workbook and paste it into the worbook you need it in.