Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select and delete specific rows | Excel Discussion (Misc queries) | |||
select cells that sum up to a specific value | Excel Discussion (Misc queries) | |||
select rows to print where there's data in specific column | Excel Discussion (Misc queries) | |||
select specific records | Excel Programming | |||
select records with a specific value | Excel Worksheet Functions |