Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub to write cell contents into its own comment
I would select a range of cells, then run the sub to write each cell's
content into its own comment. The sub to do nothing for any cell within the selection which is blank. For cells which contain formulas, to write the returned values into the comment. Thanks for insights |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub to write cell contents into its own comment
Try the below
Sub Macro() On Error Resume Next For Each cell In Selection If cell.Text < "" Then _ cell.AddComment cell.Text Next End Sub If this post helps click Yes --------------- Jacob Skaria "Max" wrote: I would select a range of cells, then run the sub to write each cell's content into its own comment. The sub to do nothing for any cell within the selection which is blank. For cells which contain formulas, to write the returned values into the comment. Thanks for insights |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub to write cell contents into its own comment
Fantastic! Works great, Jacob. Thanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELL CONTENTS WRITE TO TAB NAME | Excel Worksheet Functions | |||
CELL CONTENTS WRITE TO TAB NAME | Excel Worksheet Functions | |||
Macro to copy cell contents to comment | Excel Programming | |||
VBA - Passing Cell Contents Into Comment | Excel Programming | |||
convert cell contents into a comment | Excel Programming |