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

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

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