View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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?