Re: Won't accept sheet name

Relevant Pages

• Re: How do I use a pivot table value to reference a worksheet
  ... put the ' ' around all the sheet names, shouldn't hurt if they don't have a ... single quote between the double and the exclaimation mark in the third ... >> A5 and use that for the sheet name. ... I'm going to look at the INDIRECT function again in the help ...
  (microsoft.public.excel.worksheet.functions)
• Re: Indirect
  ... It is concatenating the single quote ' with a name and then another ... single quote plus the cell reference. ... If instead of Facilities, a cell held the Sheet name, and that sheet ...
  (microsoft.public.excel.worksheet.functions)
• Re: IF & OR Functions
  ... > Please keep all correspondence within the Group, ... >> I'm trying to check a cell on sheet 1 for certain text such as ... Prev by Date: ...
  (microsoft.public.excel.newusers)
• Conditional select and paste
  ... first two rows of this data to two different rows on the sheet (let's ... comprising Data_1_1st_2rows. ... BrianDP1977's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29110 ... Prev by Date: ...
  (microsoft.public.excel.programming)
• Re: Indirect
  ... "Roger Govier" wrote: ... But I bet the single quote is ... single quote plus the cell reference. ... If a Sheet name has spaces then it has to be enclosed within single ...
  (microsoft.public.excel.worksheet.functions)