I created a simple macro to select and color a row. However my spreadsheets are rather large with 155 columns and upwards of 500 rows. When working with such a large spreadsheet I use autofilter to isolate data. When certain columns are filtered the macro only selects the row without coloring, but works fine when the columns are unfiltered to see all data.
Sub BlueMacro()
' ' Blue Macro ' ' Keyboard Shortcut: Ctrl+e '
Rows(ActiveCell.Row).Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 15773696
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub
I have been unable to find any help with this. Any help would be greatly appreciated.
UPDATE: I have attached a dummy copy of my spreadsheet. This will make it easier to duplicate the problem. I frequently filter by F38 and others.