| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a comment to another cell - How?
I have a sheet with a number of comments. I need to be able, via vba
code, to copy these comments, with all their formats, but not the cell contents itself, to another cell on another sheet (ie only the comment). How do I do this? Thanks for your help, Dennis. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a comment to another cell - How?
Dennis,
Try Range("B2").Copy Range("B3").PasteSpecial Paste:=xlPasteComments (using "B2" and "B3" as random examples) Hope this helps, Ryan -----Original Message----- I have a sheet with a number of comments. I need to be able, via vba code, to copy these comments, with all their formats, but not the cell contents itself, to another cell on another sheet (ie only the comment). How do I do this? Thanks for your help, Dennis. . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a comment to another cell - How?
Thanks - perfect.
"Ryan Poth" wrote in message ... Dennis, Try Range("B2").Copy Range("B3").PasteSpecial Paste:=xlPasteComments (using "B2" and "B3" as random examples) Hope this helps, Ryan -----Original Message----- I have a sheet with a number of comments. I need to be able, via vba code, to copy these comments, with all their formats, but not the cell contents itself, to another cell on another sheet (ie only the comment). How do I do this? Thanks for your help, Dennis. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i copy information from a cell into a comment? | Excel Discussion (Misc queries) | |||
| Copy cell to another as a comment | Excel Worksheet Functions | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| How do I copy a comment to become the information in a cell. | Excel Discussion (Misc queries) | |||
| How do I copy text from a cell into a comment? | Excel Discussion (Misc queries) | |||
Linear Mode
