When you need to get more than one row & or One column ie if you put the
height and width as any no more than 1 , then you will have to use offset as
array function.
Anu

"Peo Sjoblom" wrote:

Can you explain how OFFSET is an array function?


--

Regards,

Peo Sjoblom





"Anu" wrote in message
...
Offset Fuc is an array function which help you to make change to the
references made dynamically. eg. Suppose you are referring to RAnge A1:b5
for
Product A and you want to change the reference to C1:D5 for Product B you
can do so by changing the Row,Column coordinates in offset function

"CLarshtnt" wrote:

What is the purpose of the Offset function in Excel 2003?