Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting rows based on column values | New Users to Excel | |||
Deleting rows with specific values | Excel Discussion (Misc queries) | |||
Deleting rows not containing one of 3 values | Excel Programming | |||
Deleting Rows with Same Values | Excel Programming | |||
Deleting Rows beased on Values | Excel Programming |