Deleting Rows with String Values
 

I created a macro to sort my worksheet by using the record macro function in
excel. When the macro executed it left rows that I do not need, most of it
are the titles and subtitles and are distributed to different columns and
rows. I want to removed this rows so that all is left is the data I sorted
out. Can someone help creat an addition to the macro I created to delete the
rows that contain this strings.
--
scaps

Deleting Rows with String Values
 

You need to post the code you have.

"Scaps" wrote:

I created a macro to sort my worksheet by using the record macro function in
excel. When the macro executed it left rows that I do not need, most of it
are the titles and subtitles and are distributed to different columns and
rows. I want to removed this rows so that all is left is the data I sorted
out. Can someone help creat an addition to the macro I created to delete the
rows that contain this strings.
--
scaps

Deleting Rows with String Values
 

Here is the code.

Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Key2:=Range("B1") _
, Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal,
DataOption2 _
:=xlSortNormal
--
scaps


"JLGWhiz" wrote:

You need to post the code you have.

"Scaps" wrote:

I created a macro to sort my worksheet by using the record macro function in
excel. When the macro executed it left rows that I do not need, most of it
are the titles and subtitles and are distributed to different columns and
rows. I want to removed this rows so that all is left is the data I sorted
out. Can someone help creat an addition to the macro I created to delete the
rows that contain this strings.
--
scaps