Change

MsgBox rngAll.Address

to

rngAll.Select

--

HTH

RP
(remove nothere from the email address if mailing direct)


"matpj" wrote in
message ...

thanks bob,

that certainly identifies the range and displays it in a box.
I need excel to actually select the rows, as I then need to perform a
cut and then insert in a seperately identified row

do you know how to do this?


--
matpj
------------------------------------------------------------------------
matpj's Profile:
http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=487981