cell reference
 

Within a vb sub I wish to capture into a variable the
current activecell postion in the format of AANNNNN (eg
a14, aa45, cd65000, etc..).

I'm sure its possible but try as I might cannot find the
syntax.

Any assistance would be appreciated.

Tks,