Macro to Change Cell Background Color From White to No Fill

Hi Everyone,

I am new here and have very limited VBA experience but extensive standard excel experience. We have some massive excel models in which my predecessor decided to format each cell's background as white as opposed to leaving the cells un-filled and hiding gridlines. Therefore the excel files are needlessly enormous. As such, because some columns and rows are other colors than white and it will take an inordinate amount of time to manually change every row and column, I need a macro that essentially says "change cells in this workbook that are formatted with a white background to have no fill".

It is probably a super simple macro to create but I am having no luck with my searches. I am probably using incorrect language. Any help would be greatly appreciated. Thank you.

Thank you! That works but it takes a very long time per worksheet.

[EDIT] Trying the second one, thanks.

Perfect thank you!