Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help on deleting row.
Below is a macro I created in sorting out a worksheet. The macro works well
but the only problem is that sort result have data that are not needed like titles subtitles, etc. I need to add some more code to clean out the unneeded rows which contain strings and are all over the rows and columns so that when I execute the macro all I would see are the sorted data that I want. Thanks for your help. 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help on deleting row.
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 Range(Selection, ActiveCell.SpecialCells(xlLastCell)).SpecialCells( xlConstants, xlTextValues).EntireRow.Delete perhaps. Test on a copy of your data. -- Regards, Tom Ogilvy "Scaps" wrote in message ... Below is a macro I created in sorting out a worksheet. The macro works well but the only problem is that sort result have data that are not needed like titles subtitles, etc. I need to add some more code to clean out the unneeded rows which contain strings and are all over the rows and columns so that when I execute the macro all I would see are the sorted data that I want. Thanks for your help. 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help on deleting row.
This does not work. It is giving an error message "Cannot use that command on
overlappping selections." -- scaps "Tom Ogilvy" wrote: 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 Range(Selection, ActiveCell.SpecialCells(xlLastCell)).SpecialCells( xlConstants, xlTextValues).EntireRow.Delete perhaps. Test on a copy of your data. -- Regards, Tom Ogilvy "Scaps" wrote in message ... Below is a macro I created in sorting out a worksheet. The macro works well but the only problem is that sort result have data that are not needed like titles subtitles, etc. I need to add some more code to clean out the unneeded rows which contain strings and are all over the rows and columns so that when I execute the macro all I would see are the sorted data that I want. Thanks for your help. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting the text without deleting the formula | Excel Worksheet Functions | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
Deleting Hyphens or Dashes from multiple cells without deleting the remaining content | Excel Programming |