Case in VBA

[tiredofit]

For some unknown reason, when I type:

.Value

VBA changes it to:

.value

Does anyone know why?

 

[steve the fish]

That can happen in this scenario:

Dim value
MsgBox Range("A1").value

so dont use keywords as variables.

 

[tiredofit]

But I haven't.

 

[Fluff]

Another possibility is if you have

Sub value()

 

[JLGWhiz]

It would have to be seen as a variable somewhere in the prior code for it to behave like that. Maybe in a For statement?

 

[tiredofit]

Checked everywhere.

Closest occurrence I have is:

Sub GetValues()

 

[Joe4]

Why not just post your whole block of code for us to see?

 

[Fluff]

Anywhere in the code window type

Dim Value

hit enter & then delete it.
It should get rid of your problem

 

[tiredofit]

Anywhere in the code window type

Dim Value

hit enter & then delete it.
It should get rid of your problem

Brilliant! It worked.

So is it an Excel quirk?

 

[Fluff]

It's the same as was discussed here https://www.mrexcel.com/forum/excel...declaration-case-post5141979.html#post5141979