Excel run problem after upgrade to Office2003

M

msenquiry

Hi,

I have some excel Macro files which is running fine in my office 97. After
upgrade the office to 2003, I find a stream of problem....

ActiveSheet.PivotTables("PivotTable4").PivotSelect "PARENT_NO.[All;Total]",
_
xlDataAndLabel
Selection.sort Key1:="R4C6", Order1:=xlDescending, Type:=xlSortValues, _
OrderCustom:=1, Orientation:=xlTopToBottom
Selection.Delete

Selection.sort does not work under the case when I multiple select (multiple
select but not in sequence) the excel row....

EDATA, WORKDAY, EOMONTH all did not work in office 2003, I have already
checked all items in Add-Ins, but it does not help...

Thanks!
Sylvia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro works on some but not for all 0
Can I Sort (A-Z or Z-A) Pivot Table Data or Fields using VBA? 4
Simple Do... Until problem 4
Code not working in Excel 2007 1
Select method of range class failed 1
Sorting columns of data 1
Sort Marco won't work in 2010 5
Is it possible from Excel 2

Top