Hello
I would like to Insert the contents of a Range of Cells into a single Comment. ie:
The contents of Range A1:A50 into a Comment placed at F1. Is there a Macro that will do this? Thanks All
Hello
I would like to Insert the contents of a Range of Cells into a single Comment. ie:
The contents of Range A1:A50 into a Comment placed at F1. Is there a Macro that will do this? Thanks All
Last edited by ChinaReg; 02-17-2009 at 02:37 AM.
Use this code
Sheet1.Cells(1, 1).AddComment ("dsad")
Chris
Last edited by VBA Noob; 02-15-2009 at 06:27 AM.
Chris, I don't think that will suffice.
Perhaps:
You may have issues pending length of strings in your 50 cells.Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thank you DonkeyOte and Chris for your replies. DonkeyOte, your answer works perfectly for my needs. I'll mark this one Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks