Yes, you'll have to enclose the ws name in single quotes.
Try:
=INDIRECT("'"&$A8&"'!AI8")
HTH
Jason
Atlanta, GA
-----Original Message-----
I am using the following to reference worksheets which
works fine except for
when the worksheet name contains a space.
=INDIRECT($A8&"!AI$8")
I dont want to remove the space from the worksheet name
because it will
cause all other sorts of issues. How can I get this to
work? Im guess it
involves enclosing the the W/S in ' ' but I've had no
sucess
Bruce
.
|