Dim rntest as Range gives us access to rntest as a range-object.
When we refer to this range-object we don┤t need to refer to it as a range, i e Range(rntest).
Dim rngtest As Range
Dim strtest As String
Set rngtest = Range("a1:a3")
strtest = "a1:a3"
Hopefully I has explained it in a understandable way.
"Windows was not able to find any keyboard. Press F1-button to try again or F2-button for cancel."
[ This Message was edited by: XL-Dennis on 2002-09-01 04:54 ]