How to fix/upgrade .sort in Excel 2007

[ofergr]

Hi.

I have a nice little macro that was activated when I pressed a button
in my Excel worksheet:
This command was part of the worksheet and it worked like a charm in
Excel XP.
I upgrade to Excel 2007, and not I get a runtime error.

The code was:
Private Sub CommandButton8_Click()
sort "SquadRow", xlAscending
End Sub

The Error I get is: Compile Error, Invalid use of property.

How should I fix my code to run in Excel 2007.

Thanks for the help,
Ofer

 

[Jim Cone]

It appears you didn't get all of the XP code copied over to 07.
The code you posted won't work in any XL version.
It should look something like...
Range("B550").Sort Range("C5")
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


<[email protected]>
wrote in message
Hi.
I have a nice little macro that was activated when I pressed a button
in my Excel worksheet:
This command was part of the worksheet and it worked like a charm in
Excel XP.
I upgrade to Excel 2007, and not I get a runtime error.

The code was:
Private Sub CommandButton8_Click()
sort "SquadRow", xlAscending
End Sub

The Error I get is: Compile Error, Invalid use of property.
How should I fix my code to run in Excel 2007.
Thanks for the help,
Ofer