Posted to microsoft.public.excel.programming

GS[_2_]

external usenet poster

Posts: 3,514

Error 1004 on Range.Text with AutoFilter

Jim's code works for me as follows...

Sub FilterRange()
Range("$A$1:$A$4").AutoFilter Field:=1, Criteria1:="1"
Application.Calculate '**rebuild formulas**
End Sub

**Required to mitigate AutoFilter causing '#VALUE!' error (#1004)**

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
autofilter raises error 1004	chfa	Excel Programming	8	November 4th 09 05:57 PM
Macro runtime error 1004 with Autofilter	Lorna B	Excel Discussion (Misc queries)	3	May 25th 07 08:38 PM
Mysterious Error 1004 caused by AutoFilter?	Ken Johnson	Excel Programming	5	March 5th 06 08:01 PM
Range Question / error 1004: method Range of object Worksheet has failed	Paul	Excel Programming	3	April 7th 05 02:56 PM
Error 1004 update autofilter and pivottable	fonz	Excel Programming	1	October 12th 04 02:59 PM

All times are GMT +1. The time now is 09:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us