S
skerdoba
I'm having a problem with Overwrite=True when using the
Text Method to insert text into a comment in my Excel
worksheet. I can insert text into my comment at the
specified character position, no problem. However it
doesn't seem to matter if I set Overwrite to true or
false, the text is always inserted rather than overwriting
existing text.
Here is the description of the method, followed by my code:
Text Method
Sets comment text.
Syntax
expression.Text(Text, Start, Overwrite)
expression Required. An expression that returns a
Comment object.
Text Optional Variant. The text to be added.
Start Optional Variant. The character number where the
added text will be placed. If this argument is omitted,
any existing text in the comment is deleted.
Overwrite Optional Variant. True to overwrite the
existing text. The default value is False (text is
inserted).
Here's my code:
Worksheets("Applic").Cells(2, 3).Comment.Text strSysTime
& " seconds.", 65, Overwrite = True
Seems pretty straightforward. Am I doing something wrong?
Text Method to insert text into a comment in my Excel
worksheet. I can insert text into my comment at the
specified character position, no problem. However it
doesn't seem to matter if I set Overwrite to true or
false, the text is always inserted rather than overwriting
existing text.
Here is the description of the method, followed by my code:
Text Method
Sets comment text.
Syntax
expression.Text(Text, Start, Overwrite)
expression Required. An expression that returns a
Comment object.
Text Optional Variant. The text to be added.
Start Optional Variant. The character number where the
added text will be placed. If this argument is omitted,
any existing text in the comment is deleted.
Overwrite Optional Variant. True to overwrite the
existing text. The default value is False (text is
inserted).
Here's my code:
Worksheets("Applic").Cells(2, 3).Comment.Text strSysTime
& " seconds.", 65, Overwrite = True
Seems pretty straightforward. Am I doing something wrong?