Tag Archives: Range.SpecialCells

Unwanted Worksheet Events? Maybe SpecialCells() Is To Blame!

I’ve written a lot on this blog about Range.SpecialCells() and how careful you have to be when using it. Here’s yet another caveat which I didn’t know about until another developer brought it to my attention. Put some data in a worksheet … Continue reading


Posted in Microsoft Excel | Tagged , , , , , , , , , , , | 4 Comments

Delete Rows If All Cells In A Given Range Are Empty

Deleting rows. We all need to do it from time to time and I often find myself referring to how to delete rows using VBA. It has a bunch of handy code snippets and notes on using Range.Find(), Range.Autofilter() and Range.SpecialCells() … Continue reading

Posted in Microsoft Excel | Tagged , , , | 1 Comment