cell reference

P

paul

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Get Pivot data not reading some cells 0
Find value of active cell in other visible worksheets 8
How to refer to the cell containing the formula? 3
VBA - Hyperlink Function Combined with Find 6
Filling in the blanks methods? 3
Conditional Formatting in VB 0
Copy unformatted value of cell via macro 0

Top