Using a Variable in a SORT statement

[Bushy]

I created a variable called "cnt". I want to use it in a SORT statement. I don't know if it can be done, I cannot make it work but I'm not sure if it is a syntax problem or just not possible.

I am using OFFICE 2003.

This is my statement:

Range("A1:E&CStr(cnt)").Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=
xlGuess , OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

 

[Bushy]

I discovered my problem. It was a misplaced QUOTE. The statement should read:Range("A1:E"&CStr(cnt)) then it all works fine.