How to show location of highlighted range at cell A1?

[london7871]

I have highlighted 3 separate ranges by mouse, say B12:B22, B25:B30, C33:C38

How to show the range of the highlighted area by VBA at cell A1?

i.e. Value of A1: B12:B22, B25:B30, C33:C38

[ikboy]

Please Login or Register  to view this content.

[rorya]

I think Selection.Address(0, 0) would be simpler. You'd need to call it from a SelectionChange event.

[london7871]

Thanks ikboy it's works.

In practice, the location of range are highlighted by my VBA, instead of mouse.

Upon using your VBA, the value of A1 is:
B111:M165,B441:M495,B276:M330

How to make it in order, i.e. value of A1 is revised to:
B111:M165,B276:M330,B441:M495

[ikboy]

Please Login or Register  to view this content.

[london7871]

Hi ikboy,

As I want the result shows at cell B1, I revise your VBA from:
Debug.Print Join(a, ",")
to
[b1].Value = Mid(s, 2)

Upon my VBA highlight the following 3 areas:
B111:M165,B386:M440,B221:M275

Your VBA show the following at B1:
386:M440

Please revise your VBA so that the result is in order:
B111:M165,B221:M275,B386:M440
(order follows first cell of range, i.e. B111, B221, B386)

[jindon]

Please Login or Register  to view this content.

[ikboy]

You should amend Debug.Print Join(a, ",") to [b1].Value = Join(a, ",")

[london7871]

Thanks ikboy, jindon and rorya, it's work.