Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hope this takes this time.
I have on sheet 1 a button that I have attached code to that is suppose to sort data on sheet 2, sheet 3, sheet 4, well it is not working. So I'm asking for help in trying to figure out what I'm doing wrong. On sheet 1 the code is: Private Sub Main Button 1() Sheets ("Sheet 1").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 Sheets ("Sheet 2").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 Sheets ("Sheet 3").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 End Sub ================= Private Sub Sort1() Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal End Sub ================= |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
a command button problem | Excel Programming | |||
Command Button Problem | Excel Discussion (Misc queries) | |||
Problem with command button name | Excel Discussion (Misc queries) | |||
Problem programming the Sort command | Excel Programming | |||
Command Button Problem | Excel Programming |