Never mind. I didn't read your reply correctly. I missed the part about
the space. Sorry for my confusion.

Thanks.
Paul

--

"PCLIVE" wrote in message
...
I just noticed that. But for some reason, my testing showed it to work
without it. Do you have any idea why that would be?

XL2002

--

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
But you'll need to add the single quotes if the sheet name in A1 has
spaces in it.
--
David Biddulph

"PCLIVE" wrote in message
...
=INDIRECT(A1& "!B75")

HTH,
Paul


--

"Steve" wrote in message
...
Hi all. In sheet1, cell A1 I have a pick list that has all the sheet
names in the workbook. In cell D5, I need a formula that is a cell
reference to B75 of whatever worksheet is selected in cell A1. Any
ideas? Thanks!