The error message suggests that there is no range named 'list' in the active
workbook.

Your code snippet was not complete. If this doesn't run I think it's pretty
conclusive that 'list' is not a named range.

Sub Test()
Dim CurCell As Range
For Each CurCell In Range("List").Cells
Debug.Print CurCell.Address
Next
End Sub


--
Jim
"dreamz" <dreamz.228zez_1138288504.3943@excelforum-nospam.com> wrote in
message news:dreamz.228zez_1138288504.3943@excelforum-nospam.com...
|
| 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
|