Reseting variables?

[Jaymond Flurrie]

I used accidentally variable named vAlue ("alue" is "area" in Finnish, v from datatype Variant) and you can guess that's not a good name for a variable. So now everytime I want to write for example:
Range("A1").Value = 1
VBE automatically corrects it to
Range("A1").vAlue = 1

How do I reset this behavior?

 

[Richard Schollar]

That's a weird one! Does it do this even in new workbooks you create?

 

[jkpieterse]

Export the module in question, remove it and then import it again.

 

[Richard Schollar]

I found I needed to save and close the workbook before reimporting the offending module otherwise it wasn't cleared.

 

[jkpieterse]

Some editing garbage needs a bit more to get rid of than others indeed. I've seen cases where an export/remove/import isn't sufficient, but an actual copy, paste into text file, remove, insert brand new module, copy from textfile does the trick.

 

[Jaymond Flurrie]

So far none of these has done the trick but the harm is only cosmetic, since vAlue seems to work as value without any problems.

So what I have tried so far is copy the module's content to a text file, remove the module, save the file, exit Excel, open Excel and paste the content of the old module back into a new module.

But no, it doesn't do it in new workbooks. I can't find vAlue by searching from the project either, so it shouldn't be there

I'll let you know if I happen to fix it somehow. I guess I could try by re-creating the file. Luckily I have nothing but two modules there so that wouldn't be too hard.

 

[jkpieterse]

Try Rob Bovey's code cleaner from www.appspro.com