Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
select all comments
How do you "select all comments" in a worksheet or workbook? Does anyone
have the VBA code for this? Pam |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
select all comments
Do you mean select all the cells that have comments in them?
if yes, Option Explicit Sub testme02() Dim myRng As Range With ActiveSheet Set myRng = Nothing On Error Resume Next Set myRng = .Cells.SpecialCells(xlCellTypeComments) On Error GoTo 0 If myRng Is Nothing Then MsgBox "No cells with comments" Else myRng.Select End If End With End Sub Manually, you can select a single cell edit|goto|special|check comments and click ok. Pamela wrote: How do you "select all comments" in a worksheet or workbook? Does anyone have the VBA code for this? Pam -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
Select Rows dependant on certain field data | New Users to Excel | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions |