Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-23-2017, 01:55 AM
enuff enuff is offline how to delete every blank and non-numeric rows without removing the header Windows 7 64bit how to delete every blank and non-numeric rows without removing the header Office 2013
Novice
how to delete every blank and non-numeric rows without removing the header
 
Join Date: Jul 2015
Posts: 6
enuff is on a distinguished road
Default how to delete every blank and non-numeric rows without removing the header

Hi,
I am using the following code to remove all blank and non-numeric rows in a dataset of a about 1200 rows:

Sub DelTest()
Columns("AL:AL").SpecialCells(xlCellTypeBlanks).En tireRow.Delete
Columns("AL:AL").SpecialCells(xlCellTypeConstants, xlTextValues).EntireRow.Delete
End Sub



In my case column AL contains only numbers.
However, this code also deletes the column header because it is text.
How can I edit it so it starts from cell AL2 down?
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to delete every blank and non-numeric rows without removing the header Delete blank rows between the two rows that contain data beginner Excel Programming 5 12-26-2014 12:29 AM
how to delete every blank and non-numeric rows without removing the header Delete All empty Rows - Print - Undo all Rows deleted Bathroth Word VBA 1 10-01-2014 01:40 PM
Removing blank pages at the end of a document Xanzia Word 3 06-01-2014 11:13 AM
first character NOT Alpha numeric or Tilde (~) delete. ksridh Word VBA 5 03-17-2014 12:45 AM
how to delete every blank and non-numeric rows without removing the header Delete Blank Rows (Cyrillic Text in Spreadsheet ) dozd Excel 1 02-22-2013 03:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft