K
Kim
I want to have a macro that will add a comment box to all the cells that the
interior color index = 6. Anyone have any ideas?
TIA,
Kim
interior color index = 6. Anyone have any ideas?
TIA,
Kim
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave O
It's pretty straightforward... what should the comment box say?
B
Bob Phillips
Kim,
Her is an example that works on the current selection.
--
HTH
RP
(remove nothere from the email address if mailing direct)
Her is an example that works on the current selection.
--
HTH
RP
(remove nothere from the email address if mailing direct)
B
Bob Phillips
Well here it is
Dim c As Range
For Each c In Selection
If c.Interior.ColorIndex = 6 Then
c.AddComment c.Address
End If
Next c
--
HTH
RP
(remove nothere from the email address if mailing direct)
Dim c As Range
For Each c In Selection
If c.Interior.ColorIndex = 6 Then
c.AddComment c.Address
End If
Next c
--
HTH
RP
(remove nothere from the email address if mailing direct)
K
Kim
Perfect! Thanks!
Kim
Kim
Bob Phillips said:Well here it is
Dim c As Range
For Each c In Selection
If c.Interior.ColorIndex = 6 Then
c.AddComment c.Address
End If
Next c
--
HTH
RP
(remove nothere from the email address if mailing direct)