How to fix/upgrade .sort in Excel 2007
 

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

How to fix/upgrade .sort in Excel 2007
 

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("B5:D50").Sort Range("C5")
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



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