This worked:
ActiveWorkbook.Worksheets("MyList").Range("B2:C37").Sort _
Key1:=Worksheets("MyList").Range("B2:B37")
I had to put the .Range in the statement before the Sort method.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
Thank you for the attempt, but this did not work. If I use your code
example, I get the same runtime error on this line:
With ActiveWorkbook.Worksheets("MyList").Sort
I don`t understand why this does not work!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
