Adrena1in Wrote:
The spreadsheets being queried are protected, (protected worksheet and
workbook), but other cells in these spreadsheets CAN be queried using
the ISTEXT function.Forgot to mention, if I do unprotect the referenced spreadsheet, the
ISTEXT function does then become able to query the specific cells. But
I don't think protection is the problem, because other cells in the
referenced spreadsheet can be accessed even when the spreadsheet
remains protected.

(Shrug)


--
Adrena1in
------------------------------------------------------------------------
Adrena1in's Profile: http://www.excelforum.com/member.php...o&userid=35929
View this thread: http://www.excelforum.com/showthread...hreadid=557224