View Single Post
  #1   Report Post  
Bruce
 
Posts: n/a
Default INDIRECT worksheet with a space in the name

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