Posted to microsoft.public.excel.programming

Barb Reinhardt Barb Reinhardt is offline

external usenet poster

Posts: 3,355

Worksheet_Activate event question

I have the following short macro that I want to put in a worksheet activate
event.

Range("A9").Select
ActiveSheet.PivotTables("PivotTable4").PivotCache. Refresh
Calculate
Selection.AutoFilter Field:=3, Criteria1:="#N/A"

I keep getting Autofilter method of range class failed.

What do I need to change?

Thanks,
Barb Reinhardt

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I disable Worksheet_activate???	broogle	Excel Programming	3	June 29th 05 10:15 AM
Worksheet_Activate event clears clipboard?	Andibevan[_2_]	Excel Programming	5	June 7th 05 03:09 PM
Private Sub Worksheet_Activate()	Teodor Bobochikov	Excel Programming	1	September 28th 04 11:03 AM
Worksheet_Activate	Pozzo	Excel Programming	5	June 7th 04 07:39 PM
Worksheet_Activate	Jim Carlock[_2_]	Excel Programming	2	September 25th 03 12:47 AM

All times are GMT +1. The time now is 08:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us