I am really curious as to why you would want to do this whether
it involves the entire worksheet (impossible), the used range,
or even a large chunk of cells.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message ups.com...
I need an excel sheet to automatically run a macro on click command, so
that this formula

=Sheet3!A1&""

is inserted in all cells in the worksheet.


Please advise on how i can go about doing this.

Cheers!
Sunny