Building the sheet name from two parts?
 

Hi,

Anybody has an idea how to get the function below to work?

-=COUNT(INDIRECT(\"'\"&B34&\" (S)\"\"'!$H:$H\"))-

The problem is the -" (S)"- part, that is the 'constant part' of the
sheet name I'm trying to refer. Is it even possible that I can make
this to work with indirect or should I found another solution?


--
Nice
------------------------------------------------------------------------
Nice's Profile: http://www.excelforum.com/member.php...o&userid=17653
View this thread: http://www.excelforum.com/showthread...hreadid=519369

Building the sheet name from two parts?
 

This worked for me

=COUNT(INDIRECT("'"&B34&" (S)'!$H:$H"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nice" wrote in message
...

Hi,

Anybody has an idea how to get the function below to work?

-=COUNT(INDIRECT(\"'\"&B34&\" (S)\"\"'!$H:$H\"))-

The problem is the -" (S)"- part, that is the 'constant part' of the
sheet name I'm trying to refer. Is it even possible that I can make
this to work with indirect or should I found another solution?


--
Nice
------------------------------------------------------------------------
Nice's Profile:
http://www.excelforum.com/member.php...o&userid=17653
View this thread: http://www.excelforum.com/showthread...hreadid=519369

Building the sheet name from two parts?
 

Thanks Bob,

Just don't understand how come I didn't found the solution now that I
see it...

:)


--
Nice
------------------------------------------------------------------------
Nice's Profile: http://www.excelforum.com/member.php...o&userid=17653
View this thread: http://www.excelforum.com/showthread...hreadid=519369