Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming a button
I created a macro that will select specific columns on different sheets and
sort them, and it works fine. I want to create a command button that will do the same thing, I copied the code from the macro and put into the button and I get an error when it tries to select the columns. What do I need to change to make this work? here is the code I have Columns("A:E").Select Selection.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A1").Select |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming a button
Don't select
With Worksheets("Sheet2") .Columns("A:E").Sort Key1:=.Range("B2"), _ Order1:=xlAscending, _ Header:=xlGuess, _ OrderCustom:=1, _ MatchCase:=False, _ Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End With -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pappaz" wrote in message ... I created a macro that will select specific columns on different sheets and sort them, and it works fine. I want to create a command button that will do the same thing, I copied the code from the macro and put into the button and I get an error when it tries to select the columns. What do I need to change to make this work? here is the code I have Columns("A:E").Select Selection.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A1").Select |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming a button
Bob,
Thank You very much, it does exactly what I wanted now. -Mike "Bob Phillips" wrote: Don't select With Worksheets("Sheet2") .Columns("A:E").Sort Key1:=.Range("B2"), _ Order1:=xlAscending, _ Header:=xlGuess, _ OrderCustom:=1, _ MatchCase:=False, _ Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End With -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pappaz" wrote in message ... I created a macro that will select specific columns on different sheets and sort them, and it works fine. I want to create a command button that will do the same thing, I copied the code from the macro and put into the button and I get an error when it tries to select the columns. What do I need to change to make this work? here is the code I have Columns("A:E").Select Selection.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("A1").Select |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
programming button again | Excel Programming | |||
programming button | Excel Programming | |||
Button: ActiveX programming | Excel Programming | |||
Programming for a save button | Excel Programming | |||
Programming behind a button | Excel Programming |