Thread: How do I set a comment in a cell with VBA?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete at Sappi Fine Paper Pete at Sappi Fine Paper is offline
external usenet poster
  
Posts: 23
Default How do I set a comment in a cell with VBA?
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?
Reply With QuoteReply With Quote