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
|