select specific rows

[Paulg]

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

 

[Dave Peterson]

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.