Forum Discussion
Deleting entire columns if background colour is red
Hi, I think I need VBA, but I would like to set something up that with a simple command I can remove entire columns from the spreadsheet if the background colour is red. I have office 365. Th...
Sorry about that. The line should be
m = wsh.Cells.Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
2nd macro has just finished running, has an 424 error object required for line -
trg.EntireRow.Delete