select specific rows
Hello, I need code to select and delete all the rows in a spreadsheet that ar blank or that begin with specific text like "subscriber name", or lik "payment type". Thanks Pau -- Paul ----------------------------------------------------------------------- Paulg's Profile: http://www.excelforum.com/member.php...fo&userid=3607 View this thread: http://www.excelforum.com/showthread.php?threadid=57419 |
select specific rows
Select that column
data|Filter|autofilter Use the dropdown arrow to apply a custom filter begins with subscriber name or begins with payment type Delete the visible rows. Repeat as many times as you need. And do one plain old filter to show just the blanks to delete them. Paulg wrote: Hello, I need code to select and delete all the rows in a spreadsheet that are blank or that begin with specific text like "subscriber name", or like "payment type". Thanks Paul -- Paulg ------------------------------------------------------------------------ Paulg's Profile: http://www.excelforum.com/member.php...o&userid=36077 View this thread: http://www.excelforum.com/showthread...hreadid=574198 -- Dave Peterson |
All times are GMT +1. The time now is 11:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com