Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I'm using this code in a function and sending in the line number as 'p' - -- With Range("O" & Val(p)) If Not .Comment Is Nothing Then With .Comment .Visible = False End With End If End With -- It is feasible to use the highest line number insted of p avoiding the need to calcualte p - or might that be significantly slower? Perhaps there's a better method to globally hide any/all comments ? Thanks - Kirk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Clearing All Comments | Excel Discussion (Misc queries) | |||
Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
Clearing Comments? | Excel Programming | |||
Code seems to crash after clearing comments | Excel Programming | |||
Code crashes after clearing comments | Excel Worksheet Functions |