You could use:
..range(.cells(r,c),.cells(rr,cc))




JohanF wrote:

Ok, thanks guys!

That gives me some ideas to work with!

I thought there should be some syntex like: .range(r,c : rr,cc) so that
one don't need the .range("") method, but if you say so, I'll try it the
long way round.

Cheers,

Johan

--
JohanF
------------------------------------------------------------------------
JohanF's Profile: http://www.excelforum.com/member.php...o&userid=33779
View this thread: http://www.excelforum.com/showthread...hreadid=535513

--

Dave Peterson