Hi William,

Good point.

I might assume that the sheet name had been spelled correctly in one line
and wrongly in the other, but that would not explain the empty value
returned by the Msgbox.

---
Regards,
Norman



"William Benson" wrote in message
...
Interesting to note however that the OP tested with Msgbox
Worksheets("Data").Range("E1").value and did NOT get the same error
message ... which they should have if the problem is the worksheet name. I
will be interested to see what they respond to this!

Bill


"Norman Jones" wrote in message
...
Hi JJFJR,

The "Subscript out of range" message indicates a failure to find a
worksheet named 'Data'.

Check that there are no spaces at the beginning or end of the sheet's
name.


---
Regards,
Norman