Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Anbody have any ideas why this macro is generating a Run Time Error 1004 on
certain machines? Sub Sort() ' ' Sort Macro ' Macro recorded 30/06/2006 by mintt ' ' Range("A2:B52").Select Selection.Sort Key1:=Range("B3"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Range("A2").Select Sheets("Cash Imprest").Select ActiveWindow.LargeScroll Down:=1 Range("G48:J98").Select Selection.Sort Key1:=Range("I49"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom ActiveWindow.LargeScroll Down:=-1 Range("A1:M2").Select Sheets("New Codes").Select Range("A1").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Want to measure macro elapsed time. | Excel Discussion (Misc queries) | |||
Run a macro automatically at a certain time | Excel Worksheet Functions | |||
Run macro based on time | Excel Worksheet Functions | |||
Entering Time Macro | Excel Worksheet Functions | |||
Can I get a macro to run at a certain time of day? | Excel Discussion (Misc queries) |