A very simple example

Dim rng As Range
Dim area As Range

Set rng = Range("A1:A2,B9:C15,M4:O11")
For Each area In rng.Areas
MsgBox area.Address
Next area


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"LoveCandle" wrote
in message ...

Hi,

What is the benifit of the worksheet function AREAS?

How can we use it with other functions?

Can you please give me an example for that?

Thank you everybody,


--
LoveCandle
------------------------------------------------------------------------
LoveCandle's Profile:
http://www.excelforum.com/member.php...o&userid=28612
View this thread: http://www.excelforum.com/showthread...hreadid=566444