| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comment in every 10 the row
Hi Can anybody help in making a VBA
I have column A and B and I need a comment "AUDIT"in column C at every 11 row of column C. I have tried the below but does not work Sub MyMacro() Dim lngRow As Long For lngRow = 11 To Cells(Rows.Count, "D").End(xlUp).Row Step 11 If Range("D" & lngRow).Comment Is Nothing Then Range("D" & lngRow).AddComment "Audit" End If Next End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show Excel comment on mouseover but not the comment indicator | Excel Programming | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| How do I remove the red corner in excel comment and keep comment? | Excel Programming | |||
| How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
| a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions | |||
Threaded Mode
