| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reading comments value into a string variable
Can't find anywhere the syntax for reading a comment into a variable in order
to write it to another cell. cmnt = ActiveCell.comment.Text produces error msg - object variable orWith block not set Many TIA'S in advance Matilda |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reading comments value into a string variable
Check for a comment first.
if activecell.comment is nothing then 'do nothing 'cmnt = "" 'whatever you want else cmnt = activecell.comment.text end if Matilda wrote: Can't find anywhere the syntax for reading a comment into a variable in order to write it to another cell. cmnt = ActiveCell.comment.Text produces error msg - object variable orWith block not set Many TIA'S in advance Matilda -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reading comments value into a string variable
Thanks for coming to the rescue again, Dave Matilda x "Dave Peterson" wrote: Check for a comment first. if activecell.comment is nothing then 'do nothing 'cmnt = "" 'whatever you want else cmnt = activecell.comment.text end if Matilda wrote: Can't find anywhere the syntax for reading a comment into a variable in order to write it to another cell. cmnt = ActiveCell.comment.Text produces error msg - object variable orWith block not set Many TIA'S in advance Matilda -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic 6 - String Reading | Excel Discussion (Misc queries) | |||
| sumproduct - reading a variable value | Excel Discussion (Misc queries) | |||
| Help with reading comments. | Excel Programming | |||
| Reading Textfile into a variable | Excel Programming | |||
| reading inside a text string | Excel Programming | |||
Linear Mode
