highlight row and column of active-cell in microsoft excel 2011 for mac add in

Highlight Row And Column Of Active-Cell In Microsoft Excel 2011 Add In Code To Work

I want to highlight the active row (the row where my cursor is) and I am greedy, I want it to change every time I change rows.

In addition, you should know in advance, the file will need to become a macro file (xlsm) because we will be adding a tiny bit of VBA DONT WORRY This is easy, so keep reading.

The formula will be Row(a1)HighlightRow where HighlightRow is the name of the defined range in Step 1.

At this point, Row 1 should be highlighted with the color you selected.

But thats not the complete end result that we want we want the row to change when our active row changes.

If it is not available, you can add it by going to FileOptionsCustomize Ribbon and turn on the developers tab.

Highlight Row And Column Of Active-Cell In Microsoft Excel 2011 Add In Code To Work

Select the workbook you are working on, and double click the sheet you want this code to work with When you double click, the code window will open, change the drop down from General to Worksheet.

If you followed the steps closely, you should be able to change active cells and have them automatically highlight VERY VERY COOL.

In order to keep the VBA, save it as an XLSM file (Macro) and it will work every time you open the file up Simply go to File, Save as, and choose the drop down for macro files.

I do believe that I was able to follow them to the letter, however I keep getting a VBA erro message saying that the subscript is out of range even though the HighlightRow is what I named the defined range in step 1.

Otherwise, replace the quotes per Steves note and remove the spaces around the sign Please post back and let us know if this works.

While thats true, I replied, as soon as you click on any cell in that row, the highlight goes away.

Is there a way to save this as a macro that works on all spreadsheets, or does this have to be done one spreadsheet at a time.

The method above keeps it highlighted, which for me, helps a lot Thank you for visiting.

Highlight Row And Column Of Active-Cell In Microsoft Excel 2011 For Mac Add In