Posted to microsoft.public.excel.programming

dreamz[_26_] dreamz[_26_] is offline

external usenet poster

Posts: 1

runtime error 1004 method range of object global failed

what's wrong with this code? "list" is a named range.

Code:
--------------------

Private Sub Test()
Dim CurCell As Object

Application.ScreenUpdating = False

For Each CurCell In Range("List")

--------------------

thanks.

--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=505327

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
runtime error 1004 method range of object '_global failed	valdesd	Excel Discussion (Misc queries)	2	October 6th 05 07:26 PM
Runtime Error 1004 Select method of Range class Failed	IanO	Excel Programming	2	June 16th 05 07:40 PM
Runtime Error 1004 - Method Range of '_Global failed'	Sworkhard	Excel Programming	3	July 9th 04 04:20 AM
Runime Error 1004 Method Range of Object Global Failed	Mohan[_5_]	Excel Programming	3	May 21st 04 03:35 PM
runtime error '1004' delete Method of Range Class Failed	Tom Kennedy	Excel Programming	0	April 14th 04 08:08 PM

All times are GMT +1. The time now is 09:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us