"Playa" wrote in message
...
I have a workbook with a formula in it and I want to place the same formula
in 27 other workbooks. The formula will be pasted in the same cell for
each
workbook. Is there a quick way to do this or do I have to copy and paste
the
formula one at a time in every workbook?

Thanks in advance.

Select all the workbooks, then put your formula in the relevant cell of the
workbook that's visible, and it should appear in the others.
--
David Biddulph