dim range as Range

[etminasm]

Hi,

I was needed one variable as Range and I tried to call it range, but when I wrote

Please Login or Register  to view this content.

then debugger fixed it to

Please Login or Register  to view this content.

it changed "R" to "r" and it changed all my ranges (f.e. Sheet("..").Range("...") to variable range and I can't go back, can't set back to Range object not range variable. When I try to Write "R" instead of "r", debugger fixes it back to "r". So now I do not have Range object, just range as variable.

Hope you understand what I mean..

Any ideas how to fix this problem?

[Andrew-R]

Don't use reserved words as varaible names. Call your range something else and your problems will be magically fixed.

[StephenR]

Yes, don't call your variable Range!