You are correct that if in another workbook, it needs the single quotes - my
mistake.
--
Regards,
Tom Ogilvy
ExcelNovice wrote in message
...
I was just playing around and found this to be true. When the cell is in
another sheet in the same workbook, it does not need the quotes if
there are no spaces in the sheet name, and does if there are spaces. At
least in Excel 2000.
---
Message posted from http://www.ExcelForum.com/