Hi,

I have a single worksheet spreadsheet whose properties show the value of the
"(Name)" to be "Sheet1"...however the "Name" property is "financial".

When I do this:

Worksheets("Sheet1").Range("A6:O106")

I get a subscript error. If I do this:

Worksheets("financial").Range("A6:O106")

I also get subscript error.

....however...whenever I change the "Name" property to be "Sheet1" instead of
"financial" and do this:

Worksheets("Sheet1").Range("A6:O106")

I get access to the range I want and all is well.

....any ideas.

Thanks