Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying comments
Hi all,
In E2:E650 I have cell comments in most cells, but not in all. I need code that copies in a super fast way all of them to AA2:AA650. The cells in AA2:AA650 may already have or have not comments. Can they be "auto sized" (I don't now if that is the proper phrase) at the same time? Your help will be appreciated. Jack Sons The Netherlands |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying comments
1. select the cells containing the comments and copy them
2. select the destination and paste/special with the comments button checked This will copy the comments. -- Gary's Student "Jack Sons" wrote: Hi all, In E2:E650 I have cell comments in most cells, but not in all. I need code that copies in a super fast way all of them to AA2:AA650. The cells in AA2:AA650 may already have or have not comments. Can they be "auto sized" (I don't now if that is the proper phrase) at the same time? Your help will be appreciated. Jack Sons The Netherlands |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying comments
Oh boy, am I stupid. Paste/special with comments only and with the macro
recorder on. Why didn't I think of that? Thanks a lot and sorry for the question. Jack. "Gary''s Student" schreef in bericht ... 1. select the cells containing the comments and copy them 2. select the destination and paste/special with the comments button checked This will copy the comments. -- Gary's Student "Jack Sons" wrote: Hi all, In E2:E650 I have cell comments in most cells, but not in all. I need code that copies in a super fast way all of them to AA2:AA650. The cells in AA2:AA650 may already have or have not comments. Can they be "auto sized" (I don't now if that is the proper phrase) at the same time? Your help will be appreciated. Jack Sons The Netherlands |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Text in Comments | Excel Worksheet Functions | |||
Can I reference comments by Cell Name? | Excel Discussion (Misc queries) | |||
Comments | Excel Discussion (Misc queries) | |||
Please help with copying comments | Excel Discussion (Misc queries) | |||
How do I export comments into another excel column as cell content | Excel Worksheet Functions |