Good morning everyone. My name is Joaquin and i am in South Africa. This is my first ever post so forgive me if i am at the wronge place. I am trying to find a macro that will find all blanck rows in my data from A3: R250 and strip the cell of the colour.
i have a macro that inserts blank rows inbetween the data change. but when a data row is coloured, it inserts the row and colours the blank row with what ever colour the row above is.I want to clear the colours from the inserted blank rows. Can any one wite me a macro that will do that please?
i have a macro that inserts blank rows inbetween the data change. but when a data row is coloured, it inserts the row and colours the blank row with what ever colour the row above is.I want to clear the colours from the inserted blank rows. Can any one wite me a macro that will do that please?