Monthly Archives: November 2012

Deleting Rows With VBA

A few years ago I posted a series of VBA samples on a forum which outlined different ways to delete rows in an efficient manner. The series proved to be very popular and, since that forum is now in decline, I’m going to resurrect those notes on here. The … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , , , , | 15 Comments

Long Worksheet ActiveX Control Names

Here’s a nice little bug for you try out. I’ve written the below step-by-step guide for Excel 2010 but it’ll ‘work’ in earlier versions too. Create a new workbook Insert an ActiveX commandbutton onto Sheet1 using Developer tab > Insert Staying in design mode … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , | 2 Comments