Microsoft Office Forums - View Single Post - how to delete every blank and non-numeric rows without removing the header

Thread: how to delete every blank and non-numeric rows without removing the header

View Single Post

Old

08-24-2017, 05:56 AM

NoSparks

NoSparks is offline

NoSparks uses Windows 7 64bit

Windows 7 64bit NoSparks uses Office 2010 64bit

NoSparks uses Office 2010 64bit

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 831

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

Default

There's no such thing as Columns("AL2:AL2000")
but there is a Range("AL2:AL2000")

Reply With Quote