Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Require assist with VBA semantic regarding worksheet selection
Hello,
I have the following subroutine for sorting a table: Sheets("Quotes").Range("A5:AB500").Sort Key1:=Range("A5"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal This works fine when I the worksheet in question "Quotes" is the active worksheet. However, when I invoke this macro while another worksheet is open, I get an error. Any assist with this is greatly appreciated. Thanks Jeff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Require assist with VBA semantic regarding worksheet selection
Hi Jeff
That is because Range("A5") points to the active sheet. Try Sheets("Quotes").Range("A5:AB500").Sort Key1:=Sheets("Quotes").Range("A5"), .... HTH. Best wishes Harald "Jeff Stryer" skrev i melding om... Hello, I have the following subroutine for sorting a table: Sheets("Quotes").Range("A5:AB500").Sort Key1:=Range("A5"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal This works fine when I the worksheet in question "Quotes" is the active worksheet. However, when I invoke this macro while another worksheet is open, I get an error. Any assist with this is greatly appreciated. Thanks Jeff |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Require assist with VBA semantic regarding worksheet selection
Harald - You are my hero. Thanks for taking time to reply.
Best Wishes Jeff "Harald Staff" wrote in message ... Hi Jeff That is because Range("A5") points to the active sheet. Try Sheets("Quotes").Range("A5:AB500").Sort Key1:=Sheets("Quotes").Range("A5"), ... HTH. Best wishes Harald "Jeff Stryer" skrev i melding om... Hello, I have the following subroutine for sorting a table: Sheets("Quotes").Range("A5:AB500").Sort Key1:=Range("A5"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal This works fine when I the worksheet in question "Quotes" is the active worksheet. However, when I invoke this macro while another worksheet is open, I get an error. Any assist with this is greatly appreciated. Thanks Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock worksheet, based on dropdown selection prior worksheet | New Users to Excel | |||
why does worksheet require two different forms of same formulas | Excel Worksheet Functions | |||
Please assist... | Excel Worksheet Functions | |||
Formula Assist | Excel Discussion (Misc queries) | |||
Please assist | Excel Worksheet Functions |