Hi,

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


Dim range as Range
then debugger fixed it to 


Dim range as range
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?