Barney

Activecell.Offset(-3,-1)

Be aware you may raise an error if this reference doesn't exist



--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Barney" wrote in message
...
In a macro or formula, how do I make a reference to a cell by location?
i.e. 3 cells to the left and up one row?

Thanks,

Barney