| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Verify if Comment exist in a cell
How do you verify if a comment exist in each cell in a worksheet using VBA
code. The following VBA code works for a verifying comments in a range: If Range("A:A").Comment.Visible = True < The following VBA code does not work for verifying if comments exist in a cell: If ActiveSheet.Cells(RowNbr, 1).Comment.Visible = True < Received the following error: Object varible or With block variable not set. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date in cell comment | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| How do you keep a comment close to the cell it relates to in Exce. | Excel Discussion (Misc queries) | |||
| Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Threaded Mode
