fahadakbar
Board Regular
- Joined
- May 15, 2014
- Messages
- 63
Hello friends | ||||||
I am trying to put some comments in a sheet through VBA | ||||||
I know that how to put in a comment. I can use | ||||||
Range("A1").AddComment("vvv").Visible =False | ||||||
and this will work perfectly | ||||||
However, when I use another reference style "Cells" - it doesn't work e.g | ||||||
Cells(1,1).AddComment("vvv").Visible = False | ||||||
this will give me a object definition error-- | ||||||
Does anyone know why it happens ? and hot to fix it ? |
<tbody>
</tbody><colgroup><col span="7"></colgroup>