You could record a simple macro.
Then replace your range in
VB Editor (Alt F11)
e.g Range("A1:H23") with the text Range("A1").CurrentRegion.Select.
then add a macro button (See link)
http://www.mrexcel.com/tip068.shtml
VBA Noob
--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
View this thread:
http://www.excelforum.com/showthread...hreadid=563135