Excel vba get range of user selected range by mouse?

Up vote 1 down vote favorite share g+ share fb share tw.

This is not the usedrange issue. For example in excel user selects a range (possibly empty) using mouse, let's say B4:C12. And let's say after this without deselecting the range user presses the macro, and macro should tell B4:C12.

Can anyone show example? Thanks a lot in advance! The macro should be smth along the lines of the following: Sub showrng() MsgBox SelectedRange.

Address(ReferenceStyle:=xlA1) End Sub excel vba excel-vba excel-2007 excel-2003 link|improve this question asked Sep 10 '10 at 17:25sdfg2225 60% accept rate.

Sub macro1() MsgBox Selection. Address(ReferenceStyle:=xlA1, _ RowAbsolute:=False, ColumnAbsolute:=False) End Sub HTH!

Of course, it does! Thanks! – sdfg Sep 10 '10 at 17:53 1 +1 but ReferenceStyle:=xlA1 would match the requirements of the question more closely – barrowc Sep 11 '10 at 0:28 1 @barrowc Yup ... intended to type that.

Edited. Thanks! – belisarius Sep 11 '10 at 3:40.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.