dreamz wrote:
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")

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



Go to Insert/Name/Define , find "list" on a list and check if you see
name of worksheet in that line.
If yes, it means that "list" is defined on specific sheet only, and
doesn't not exist when other sheet is active.
If you don't see a name of worksheet - I don't know why it doesn't work :)