How do I set a comment in a cell with VBA?
Record a macro while doing it manually, read it afterwards, and you will see
the light.
Or at least something on a bright white background.
HTH. Best wishes Harald
"Pete at Sappi Fine Paper"
skrev i melding ...
I should have thought that the command:
range("A1").comment = "This is a comment in cell A1"
would work ... but it doesn't. I get an error message which reads:
"Object variable or With block variable not set"
Can anyone help?
|