Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sortTable works in 2003 but not in 2007
Hi
I am a newbie and received a file use VB to create a league table. The results are entered on a separate sheet and the league table updates automatically when the league table worksheet is selected. Great in 2003 but when i open the file in 2007, i get a "Compile error, invalid use of property". Basically the code below seems to be the problem, but i have no idea how to correct it. Private Sub sortTable() sort sortRange:=Table.Range("leagueTable"), _ sortKey1:=Range("A4"), _ sortKey2:=Range("Y4"), _ sortOrder2:=xlDescending, _ sortKey3:=Range("W4") ' Range("B3").Select End Sub Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA errors in 2007 (works fine in 2003) | Excel Discussion (Misc queries) | |||
SUMIF formula works in Excel 2003, does not work in Excel 2007 | Excel Discussion (Misc queries) | |||
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 | Excel Worksheet Functions | |||
Works in 2007 but not 2003 | Excel Discussion (Misc queries) | |||
xls file works fine in Excel 2000 and 2007 but crashes on opening in 2003 | Excel Discussion (Misc queries) |