Worksheet activate place text in cell.

Hi all,

Think I'm being dumber than normal.

I have a workbook.

When a worksheet (intro) is selected I need the cell B28 to read "No of players that have played for TEAM"

Now the TEAM can be any team, but it is named properly on a sheet called setup in cell D1 and the cell is named MyTeam.

I think that the code should read

Please Login or Register  to view this content.

I can't fathom out what the XXXXX code needs to be to complete this.

Please can someone help me?

Thanks.

I have managed to get this far

Please Login or Register  to view this content.

I have tried both & and + but cannot get it work

SOLVED:

Please Login or Register  to view this content.

Give this a try:

Please Login or Register  to view this content.

If the cell in sheet Setup is named myteam, you can simply use

Please Login or Register  to view this content.

Thanks ... I'll give this a spin too.