compile error: duplicate declaration in current scope

[3earth]

My code is below.

Please Login or Register  to view this content.

I had only the checkbox and Select at least ONE location which worked. I then added the Enter DATE in Minor Problem Behavior. It worked. Then I added the rest. Now I get the error "compile error: duplicate declaration in current scope."

I do not know what to do to fix.

[TMS]

You have repeated the line:

Please Login or Register  to view this content.

Regards, TMS

[3earth]

Does that mean that I just need to delete the Dim c As Range after the first one and everything else stays the same?

[stanleydgromjr]

3earth,

Try:

Please Login or Register  to view this content.

[3earth]

Thank you works beautifully

[TMS]

Kind of wondering why you're looping. There's only one cell in each of the ranges,

Please Login or Register  to view this content.

could be written:

Please Login or Register  to view this content.

And if Range("F63") is numeric, it would be better to put:

Please Login or Register  to view this content.

Regards, TMS

[stanleydgromjr]

TMShucks,

Nice catch - I must be sleeping today......

[TMS]

No. I missed it first time. I just focused on the stated problem ... the multiplicity of Dim statements. Ho hum ..., easy done.