Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need help with writing better performance code for comments formating.
Here is my code: For Each c In Cells.SpecialCells(xlCellTypeComments) c.Comment.Visible = True c.Comment.Shape.Select True With Selection .Placement = xlMoveAndSize .PrintObject = True .AutoSize = True .Left = c.Left + c.Width + 3 .Top = c.Top + 2 End With c.Comment.Visible = False Next c In sheet with ~550 comments it takes about 4 minutes. Do you have any ideas ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
Formating cells with comments attached | Excel Discussion (Misc queries) | |||
in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
XLL performance in NT and XP | Excel Programming | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) |