Forum home » Delegate support and help forum » Microsoft Excel Training and help » best training excel intermediate - VBA
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
best training excel intermediate - VBA
Resolved · Low Priority · Version Standard
Reply Fri 19 Oct 2007, 15:45Delegate Dominique said...
Dominique has attended:
Excel VBA Intro Intermediate course
VBA
How do I find blank rows of data and delete them?
For upcoming training course dates see: Pricing & availability
RE: 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
|