Run Time Error 438 Object Does not Support this property...

kitaro75

New Member
Joined
Oct 17, 2006
Messages
1
I have VBA code in a macro which works fine in Excel 2003 but gives me an error when ran in Excel 2000. Can anyone please tell me what part of the code is incompatable and what I need to do to fix it so that is will work in both versions.

Thanks

Sub Button1_Click()
Range("AW9:CU" & Range("AX5").Value + 7).Select
Selection.Clear
Range("AW8:CU8").Select
Selection.Copy
Range("AW9:AW" & Range("A5").Value + 7).Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("A8").Select
Dim pt As PivotTable
Dim ws As Worksheet

For Each ws In ActiveWorkbook.Worksheets
For Each pt In ws.PivotTables
pt.PivotCache.MissingItemsLimit = xlMissingItemsNone
pt.PivotCache.Refresh
Next pt
Next ws
End Sub
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
The MissingItemsLimit property isn't in Excel 2000. There is no equivalent, so you will need to remove that line.
 

Forum statistics

Threads
1,136,606
Messages
5,676,772
Members
419,649
Latest member
ljohnson88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top