Areas Collection
Back to Index | Table of Contents
|
The Areas collection contains a few block of cells within a specific selection i.e. multiple ranges to create one multi-range. Let's look at an example... Sub AreasDemo() The above macro use the Union function to combine 3 non-contiguous ranges. AreasInMyRange will return 3 as we use the Areas.Count method to calculate the 3 areas in myRange.
|
WidgetBucks - Trend Watch - WidgetBucks.com |