Ignore the extra "Range" in second line.
On Mon, Apr 8, 2013 at 6:03 PM, Abhishek Jain wrote:
> You can give a try to:
>
> With ActiveWorkbook.Worksheets("*yoursheetname*").Sort
> .SetRange Range("B2:C37")
> .Header = xlGuess
> .MatchCase = False
> .Orientation = x
You can give a try to:
With ActiveWorkbook.Worksheets("*yoursheetname*").Sort
.SetRange Range("B2:C37")
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
On Mon, Apr 8, 2013 at 5:01 PM, wro
I have a VBA macro created in Excel 2010, where it works fine. However, I
get the following error when I run it in Excel 2003 (file saved in 2003
format):
Runtime error '438':
Object doesn't support this property or method
Range("B2:C37").Select
Range("C2").Activate
ActiveWindow.S
