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?

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?

Easiest is:

range("A1").notetext text:="This is a comment in cell A1"

--
Regards,
Tom Ogilvy


"Pete at Sappi Fine Paper"
wrote in message ...
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?

Hi Pete,

For an existing comment try:

Range("A1").Comment.Text _
"This is a comment in cell A1"


or to create the comment:

With ActiveSheet.Range("A1").AddComment
.Text "Howdy!"
End With

---
Regards,
Norman



"Pete at Sappi Fine Paper"
wrote in message ...
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?

Thanks Harald, but I tried that and it didn't work. Even copied the macro
and pasted it into my program. Same error.

"Harald Staff" wrote:

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?

Thanks Tom! That worked!

"notetext" instead of "comment" ... now THAT'S intuitive.... *grumble grumble*

"Tom Ogilvy" wrote:

Easiest is:

range("A1").notetext text:="This is a comment in cell A1"

--
Regards,
Tom Ogilvy


"Pete at Sappi Fine Paper"
wrote in message ...
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?

Hi Pete,


"notetext" instead of "comment" ... now THAT'S intuitive.... *grumble
grumble*

See Tom's earlier post:

http://tinyurl.com/77a7l


---
Regards,
Norman



"Pete at Sappi Fine Paper"
wrote in message ...
Thanks Tom! That worked!

"notetext" instead of "comment" ... now THAT'S intuitive.... *grumble
grumble*

"Tom Ogilvy" wrote:

Easiest is:

range("A1").notetext text:="This is a comment in cell A1"

--
Regards,
Tom Ogilvy

Thanks Norman. I'll bear this in mind, but Tom's solution worked so I'm
sticking with that for the moment.

"Norman Jones" wrote:

Hi Pete,

For an existing comment try:

Range("A1").Comment.Text _
"This is a comment in cell A1"


or to create the comment:

With ActiveSheet.Range("A1").AddComment
.Text "Howdy!"
End With

---
Regards,
Norman



"Pete at Sappi Fine Paper"
wrote in message ...
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?