| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting UsedRange of a Worksheet
How can I sort only the UsedRange of each Worksheet in a workbook? This is
what I have so far and it will not let me. Sub Sort () For Each wks In Worksheets wks.UsedRange.Sort Key1:=Range("L3"), Order1:=xlAscending, _ Key2:=Range("A3"), Order2:=xlAscending, Header:=xlGuess Next wks End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Conditional Formatting to UsedRange on Worksheet | Excel Programming | |||
| Redefine UsedRange property of Worksheet Object | Excel Programming | |||
| Saving worksheet as CSV with correct usedrange... | Excel Programming | |||
| Why is worksheet.usedrange empty? | Excel Worksheet Functions | |||
| Redefining the UsedRange of a Worksheet | Excel Programming | |||
Threaded Mode
