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