Hey, how did that part get added after I read it!!!! <bg.

Sorry about missing your final paragraph.

Peter T wrote:

I had attempted to qualify that portion with -
"Assuming code is in a normal module (see later)" etc

Then later I tried to make the clear distinction that the dot ref is
definitely required in a sheet module, if Range does not pertain to that
sheet.

But it did mean scrolling down to see it <g

Regards,
Peter T

"Dave Peterson" wrote in message
...
Just this portion:

With mySheet
set rng = Range(.Cells(1,1),.Cells(2,2))
End With

Range does not need the preceeding dot as the reference to the parent
sheet
is linked with the dots that precede Cells. But I agree with all the
recommendations to include it.

======
It still depends on where that code is located.

======
And for me, Integer as a variable type is gone.


<<snipped
--

Dave Peterson

--

Dave Peterson