On Sat, 23 Feb 2008 10:51:01 -0800, dgd1212
wrote:

This line errors out:
Set hols = Range(Sheets("Hide").[E2], Sheets("Hide").[E11])
Looks like it should work. What am I missing?
Thanks


Works OK he

==================
Sub foo()
Dim hols As Range
Set hols = Range(Sheets("Hide").[E2], Sheets("Hide").[E11])
Debug.Print hols.Address
End Sub
=====================
--$E$2:$E$11
=====================

What is the error message?
--ron