Quote:
Originally Posted by Gizzmo
Sorry attached the wrong file try this one!
|
Thank you very much! It does exactly what I was looking for.
Two questions: Normally, if you insert a comment into the cell you can format the box and make it as big as you want. Here, though, even if you format it to see all entries - next time you run the script the comment box shrinks to default size. Is ther a way to make it either expand automatically with each entry or format from the get go so it'll stay big enough to accomodate all entries. otherwise it displays about 5 lines only.
I tried to look up the code to change the ranges to my needs and the only way I know - View Code in the Worksheet did not show any. How do I see the VBE code in here?
Thanks again for your attention to this,
Art