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

Pay CLOSE ATTENTION to the ' placement in the formula
=INDIRECT("'"&A1&"'!C1")
=INDIRECT("'"&A1&"'!C1")

--
Don Guillett
SalesAid Software

"Bruce" wrote in 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

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
.

=INDIRECT("'"&A1&"'!C1")

thats " ' " & a1 & " '!c1"
--
Don Guillett
SalesAid Software

"Bruce" wrote in 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

Thanks guys, got it sorted...

"Don Guillett" wrote:

=INDIRECT("'"&A1&"'!C1")

thats " ' " & a1 & " '!c1"
--
Don Guillett
SalesAid Software

"Bruce" wrote in 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

glad to help

--
Don Guillett
SalesAid Software

"Bruce" wrote in message
...
Thanks guys, got it sorted...

"Don Guillett" wrote:

=INDIRECT("'"&A1&"'!C1")

thats " ' " & a1 & " '!c1"
--
Don Guillett
SalesAid Software

"Bruce" wrote in 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