J
J Streger
I have a sheet where I originally created a global const as:
Global Const RAMPUP = "RU"
Well I decided that rather than that I wanted to do an enumeration. So I
deleted the global const and created:
Public enum TestTypes
RampUp
end enum
Except that after typing VBA gave me this:
Public enum TestTypes
RAMPUP
end enum
In fact, everytime I type rampup in the code it becomes capitalized. I did a
search and it exists nowhere in my code. Excel doesn't show it in the object
browser, and I restarted Excel, but it seems to have a die hard memory that
rampup = RAMPUP. It's done this with 3 other variables I made Global
constants and then deleted. Is there a way to stop this from happening?
--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003
User of MS Office 2003
Global Const RAMPUP = "RU"
Well I decided that rather than that I wanted to do an enumeration. So I
deleted the global const and created:
Public enum TestTypes
RampUp
end enum
Except that after typing VBA gave me this:
Public enum TestTypes
RAMPUP
end enum
In fact, everytime I type rampup in the code it becomes capitalized. I did a
search and it exists nowhere in my code. Excel doesn't show it in the object
browser, and I restarted Excel, but it seems to have a die hard memory that
rampup = RAMPUP. It's done this with 3 other variables I made Global
constants and then deleted. Is there a way to stop this from happening?
--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003
User of MS Office 2003