View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dreamz[_26_] dreamz[_26_] is offline
external usenet poster
 
Posts: 1
Default 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