VBA intellisense data

[glfiedler]

I dimensioned a variable as Dim rowS without thinking. I have been coding for decades so I know using "rowS" as a variable is, of course, a bad idea even thought the vba editor is smart enough to take context into account and keeps running smoothly. As soon as I realized my mistake I deleted the Dim rowS and replaced it with Dim rowStart. I then, of course, corrected the code to match the new variable name.
Every thing runs fine except for "intellisense". Now when I want to use the Excel word "Rows" intellisense lists "Rows" but as soon as I select it using the tab key it enters "rowS" into the code.
I know, so what. It just looks sloppy and I am not a sloppy programmer, generally.
Is there a way to clear previously dimensioned variables from the editor's memory?

 

[smozgur]

Declare the same variable as Rows,

Dim Rows as Range

Then let VBE to autocomplete by typing Sheet1.Rows.Count for example, and clear the declaration.

It should be cleared.

 

[glfiedler]

Thank you! That solved the problem. In fact the editor automatically fixed all the entries of "rowS" too.