Help Debug error - object required

[kellynicolebarrett]

I'm really new to macros and need help desugging something.
I recorded a macro that (using the example below) when I click on a button it hides all columns in my sheet except the month of February. Then (this is the bit I'm struggling with) I need to hide all the rows with cells with no fill colour in February's range of cells (here it's H5:K212).

I don't understand the error really so any help would be appreciated!

I need to do this with all the months of the year so if I can understand my example month (Feb) then I can adapt the range of cells to suit the others.

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[alansidman]

Remove the .Select from the line of code.

Alan

[JOHN H. DAVIS]

Try taking out the .select

Please Login or Register  to view this content.

[kellynicolebarrett]

I took the .select out but it still doesn't work. I've attached my sheet to this post, maybe one of you would be so kind as to have a look.

PA Yearly Servicing Schedule New.xlsm

[romperstomper]

It works here.

I think you can replace all your borders code with just:

Please Login or Register  to view this content.