Re: Indirect Function & Punctuation Marks

joshuafandango@xxxxxxxxxxxxx wrote:
Hi guys,

I can't find anything relating to this on t'internet so....

I want to sum the range M1:M300 in each *** in my workbook (except
my active ***) based on a list of I have in column A of the ***
names (extracted via VBA).

I expected the formula: =SUM(INDIRECT(A1&"!$M$1:$M$300")) to work when
copied down in column B, however many of the *** names contain
punctuation marks which returns #REF!.

Anyone any ideas of a fancy way round this? I ask mostly for reasons
of interest as the simple answer is definately going to be to change
the *** names.

Cheers,
JF


you need to enclose the *** names in ''.
try =SUM(INDIRECT("'"&A1&"'!$M$1:$M$300"))
it should work
.