Gordon
Only in code, let us know what you are trying to do more specifically

Signature
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> Anyway to take text from sheet 2 in a workbook and put it into comments in
> a cell on sheet 1?
>
> Gordo
David McRitchie - 03 Feb 2005 18:37 GMT
Hi Gordo,
You might take a look at
http://www.mvps.org/dmcritchie/excel/ccomment.htm
for some ideas, or at least to help you refine your question.
---
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
> > Anyway to take text from sheet 2 in a workbook and put it into comments in
> > a cell on sheet 1?