Donovan
You do not need VBA.
The CELL function is what you want.
See Bob Phillips's site for info.
http://www.xldynamic.com/source/xld.xlFAQ0002.html
Gord Dibben MS Excel MVP
On Fri, 9 Jun 2006 16:16:45 -0500, Donovan
wrote:
Thanks. I take it there is no Function other than VBA to doing it.
I was trying to avoid VBA too keep the file management simple and small
but I guess I have no choice.
Thanks again.