Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
I have a several (almost identical) spreadsheets that I regularly need to delete rows based upon the value displayed in each cell within the range C4:C63. The cells in this row get their value via a link from another workbook. What I am trying to achieve is: if cell C4 shows 0 then delete row and so on down to and including row 63. I would like, if possible, for this macro to be available every time I open Excel so that I can call it whenever I need it rather than re-writing it every day.
Thanks for your help.
Mel
Thanks for your help.
Mel