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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks