When a user clicks and drags to highlight a range, how do I identify
that range in a macro?

Say the user highlights cells E6:G17, I want to give them the ability
to click a button that will do several things to that range.

I have tested my macro, but only when I have used a known range.


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=535965