without code try this:
suppose your data is in column B (if not add a column at right of your
data column), put 1 in column A to the right of cells that you want to
delete (whole row) and also put 1 on right of cells that are empty,
when you have entered 1 in the right of cells that you want to delete,
select column A and press F5 to open Go To window press Special tab
and click Constants and then Ok. it will select cells that contain 1
(actually these cells are in rows that you want to remove) now press
Ctrl+- (Ctrl and minus sign) it will open a Delete window, select
Entire row and click Ok. All rows will be deleted which contain 1 in
col A.
hope this would serve your purpose.
Paulg Wrote:
I have a text report I import into excel that has headers and blank rows
between the headers.
I need some code to delete rows that begin with specific words, such as
"subscriber", or "Payment type", and also deletes any blank rows.
Thanks
--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread:
http://www.excelforum.com/showthread...hreadid=574204