sort macro

Hi all, I have a sheet with information and i use the sort method to display the information i would like to see on top. This works for a few but sometimes displays the sort results in rows 2000 onwards instead of displaying it on top. Could someone help me see why? Sub ofinumber() ' '...

A simple sort routine is being used across a number of reports, but there's a few instances where the sort begins on the second row (row 13) and the not the first (row 12). It's strange, because the same code works fine in the majority of cases. Any ideas? Thanks in advance...

I am trying to sort data first by what is in column A and then by what is in column E, in respect to column A. For example, column A has 120 rows listing 6 types of animals with varying times of repetition, and column E has the dates each animal was adopted, with varying times of repetition. I...

I have an auto sort macro that arranges entries based on the date placed in the column. Sub Sort_Macro() Range("A25:O2000").Sort Key1:=Range("A26"), Order1:=xlDescending, Header:=xlYes, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal End Sub...

Hello, I am looking for some code which will return the location of the form button which is being clicked on to activate the macro. I would like to avoid using an active.x button if at all possible. In this way I can use the same macro on a column of buttons to trigger an action based on...