='O'' RAMBO'!A1+....

One way of getting the right syntax for this kind of stuff is to let excel do
the heaving lifting.

Select a cell on that troublesome sheet: O' Rambo
Edit|copy
Off to an unused cell on a different sheet in the same workbook
Edit|paste special|click Paste Link

Look at how excel builds the formula for you.

(Clean up that pasted cell when you're done.)



ankur wrote:

Hi Experts,

I am actually wrting a program which will populate some of the cells
in sheet 1 with a formula which looks like .... "=John!A1+David!
A1+Smith!A1"

I am simply trying to add cell A1 values in various sheets which are
named as individual names.

The problem comes when some one's name is like O' RAMBO etc...

I think case the formula throws an error because formual does't
take '

Any workaround for this one?

Thanks A Lot in advance.

Regards
Ankur

--

Dave Peterson