VBA Variable name Problem

[The_Captian]

Using Excel 2003 SP0

I created a variable called "comment" as a string. Later realized that "Comment" was a method I needed to use, so I changed the variable name to "myComment".
However, now every I try to use ".Comment" the VBA editor changes it to ".comment" and gives an object variable not defined error.

for example, the code:
Sheets("S1").Range(myCell).Comment.Shape.TextFrame.AutoSize = True
is changed to:
Sheets("S1").Range(myCell).comment.Shape.TextFrame.AutoSize = True

and errors.

Is there a way to force a reset of the VBA editor. I have tried closing, re-starting etc. but it refuses to let me use "Comment" as a method.

Thanks in advance for any replies.

 

[wigi]

Did you delete that line of code saying Dim comment As String?

 

[The_Captian]

Yes, I completely removed it. It's like it refuses to acknowledge that it's gone.
(Even used Find to look for it anywhere else)

 

[Ragnar1211]

Have you exited Excel and reopened?
It may be in memory.

 

[The_Captian]

Yes, I have even re-started the computer.
I may have replaced the variable name "comment" with "myComment" using find/replace. Not sure why that would matter though.

"comment" exists nowhere as a variable in my code, but the editor still continues to auto-correct the ".Comment" method to ".comment" as if it did.

 

[Ragnar1211]

Copy the code, delete the module, add a new module, paste the code?

 

[The_Captian]

The code is not within a module. It is within the sheet (the workbook has multiple sheets with buttons for running code in each sheet). The naming issue is happening everywhere within the project though (every sheet & in the 1 module).

I deleted the module and pasted code back in, but no luck.

Don't really want to delete the sheet as it has many custom named ranges referenced by the code in it.

 

[shg]

As to the capitalization, just add and then immediately delete this line:

Dim Comment

What is myCell? As writtem, it should be a string variable containing the address of a single cell.

 

[The_Captian]

You are correct, myCell is a string holding a cell location.

Tried as you suggested. Created line:
Dim Comment as String
Dim comment as String

Tried one, deleted it, then the other, and deleted it.
Still no luck!

Even the simple line below fails:
Range("A1").comment = "Hello"

Although it works fine in any other project. (Note that .AddComment works fine. I need to access the .Comment method though)

I even tried deleting all the code and all worksheets (other than new insrted one) and all modules. Still will not let my use ".Comment" method in new sheet in this project!

 

[shg]

That syntax doesn't work for me at all. This does, if the cell already has a comment:

Range("A1").Comment.Text "Hello"