best training excel intermediate - VBA

Hi Dominique

Thank you for your question. As this requires a reasonably lengthy bit of coding, I'll refer to you to a page that shows the code. Please bear in mind that I haven't tested this myself so try it on a small spreadsheet first to see if it works.

The code should:
- delete all blank rows in the worksheet you specified or in the active sheet except rows
- that contain formulas
- that are precedents of a formula in a cell, e.g. if a formula in A6 references cells in rows 1 to 5, rows 1 to 5 will not be deleted.

For the code, please see www.cpearson.com/excel/deleting.htm

I hope this works for you.
Amanda