Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey everyone...
I have a spreadsheet that is the result of a previous macro I have written, and I now in another macro I essentially want to format this sheet. The sheet is always going to have a header in the first row and be varying in length. I want to sort the column in descending order by column C, ignoring the header in the top row. My previous attempts have failed! I tried pre-recording macro, but the sort dimensions are absolute, and I need mine to be relative. I tried entering the range as "Range(Cells(2, 3), Cells(last_row, 3))" where last_row is defined previously as the last used row in the sheet. Anyone with tips would be very much appreciated! Thanks for the help, Derek |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Specify shape dimensions | Excel Discussion (Misc queries) | |||
Fix dimensions | Excel Discussion (Misc queries) | |||
Varying Data Sort Macro. | Excel Programming | |||
Three Dimensions? | New Users to Excel | |||
Sort array with 2 dimensions? | Excel Programming |