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