comments in excel
How can I copy / cut & paste a table including all the formatting into a
comment in an excel spreadsheet |
|
suppose you have entered some in cell D8 e.g. rv
you want this to be entered in comments of cell G10 try this url Public Sub test() Dim x As String x = Range("d8").Value Range("g10").AddComment x End Sub ========== see whether you get what you want. perhaps itis not possible to copy the format etc. EGYPTIAN SUE <EGYPTIAN wrote in message ... How can I copy / cut & paste a table including all the formatting into a comment in an excel spreadsheet |
All times are GMT +1. The time now is 10:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com