AboutRangeSelection

A question regarding "AboutRangeSelection" procedure on Chapter 11 in the CD, Excel 2003 Power Programming with VBA by John Walkenbach.

Please Login or Register  to view this content.

I am quite puzzled about the above statement. Lets say the my range selection are: A3, B2:D5.
Then FirstAreaType= Cell from the AreaType function and same for WhatSelected.
Set UnionRange = A3
CurrentType = Cell

No execution of this statement : If CurrentType = "Block" Then NumBlocks = NumBlocks + 1
because CurrentType is a Cell

Wouldn't Set UnionRange becomes a range that unifies A3 and A3? I think that I just didn't understand what the Area in Union(UnionRange, Area) represents?

And let say the next range is processed: B2:D5
Then we have
CurrentType is Block, So NumBlocks= 1
Set UnionRange = UnionRange(A3, B2:D5) ? (1st Question)

I understand that A3 is cell and B2:D5 is block and althought they are different types of range, we can have a collection of ranges that contains those two types of range in the UnionRange.

(2nd Question)
How can i display the arguments in UnionRange right after Set UnionRange = Union(UnionRange, Area)

Could you please help? Thank you in advanced.

Hello curiousGrace,

Welcome to the Forum!

I am going to keep this simple and not address anything other than what the statement below does.

Please Login or Register  to view this content.

The object variable "UnionRange" will be a Range Object that contains the both ranges of "UnionRange" and "Area", both of which are Range Objects themselves.

Let's look at the what is happening using your example.

Please Login or Register  to view this content.

In the first statement, UnionRange is initially set to Range("A3") of the active worksheet. The second statement reassigns UnionRange to contain both the initial range, Range("D3"), and the Range("B2:D5"). If we check the address of UnionRange it would like this "D3, B2:D5".