Shade visible rows only - when value in column changes

[annaisakiwi]

Hi All

I have a sheet with a lot of data, and a macro set on a button which hides any rows where the colour is shaded dark grey in a particular column.

I want to put on shading when the value in column A changes (like banding in a table),but only when the value changes and the rows are visable.

Would appreciate any help at all with this.

Hopefully my post makes sense!