Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Upgrade to EXCEL 2007 Problem | Setting up and Configuration of Excel | |||
Excel Upgrade to 2007 Questions | Excel Discussion (Misc queries) | |||
MS Query problem after upgrade to MS Excel 2007 | Excel Discussion (Misc queries) | |||
confusion about upgrade to excel 2007 | Setting up and Configuration of Excel | |||
To upgrade excel 2007 | Excel Discussion (Misc queries) |