Tag Archives: is there a coloured cell on the row

VBA to check if any cells on the row have a colour

This quick script will scan through the worksheet(“X”) and if there is a coloured cell on the current row, it will put a 1 in the first empty column so you can filter easily. Make sure you change the name of the worksheet in the code to reflect the one you are checking. ‘Speed up […]

the web designer group uk
the webdesigner group logo

Close Button

Web Site Designed by

The Web Designer Group