98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » best training excel intermediate - VBA
best training excel intermediate - VBA
Resolved · Low Priority · Version Standard
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?
Tue 23 Oct 2007, 14:46Trainer Amanda said...
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
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. |
Excel tip:Do a fast scrollIn big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle. |
