Hi

A1 or R1C1 reference style;
Reference to range or to cell or to named range;
Reference to range/cell on same sheet/another sheet/another workbook;
Absolute or relative reference (separately for rows and columns).
Combinations;
Functions/features returning cell/range reference:
Worksheet: OFFSET(),INDEX(),INDIRECT()
VBA: Range(), Cell(), Names(), [NamedRange]


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"virendra" wrote in message
...
I want to know the different addressing techniques used in MS Excel.. Can
anybody help me out?