Cell Address
 

Hello Experts,

I would like to know how can I obtain the cell address in
integer format. For example, now when I use to get the
address function I will get a return something
like "$F$4", if I were to use the addresslocal function
with false columnabsolute and rowabsolute attributes, I
will get F4.

How can I get a return of the format like ..cells(2,5)
for example?

Can somebody please help.

MANY THANKS IN ADVANCE...

LSB

Cell Address
 

The following example might have been more on target if it related
to the line of code you wanted to change, but the following
should show you what you need.

msgbox activecell.address -- $F$4
msgbox activecell.address(0,0) -- F4
msgbox activecell.row -- 4
msgbox activecell.column -- 6

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"LSB" wrote in message ...
Hello Experts,

I would like to know how can I obtain the cell address in
integer format. For example, now when I use to get the
address function I will get a return something
like "$F$4", if I were to use the addresslocal function
with false columnabsolute and rowabsolute attributes, I
will get F4.

How can I get a return of the format like ..cells(2,5)
for example?

Can somebody please help.

MANY THANKS IN ADVANCE...

LSB

Cell Address
 

Hi Lsb,

I would like to know how can I obtain the cell address in
integer format.


Dim lRow as Long
Dim iCol as Integer
lRow=Activecell.Row
iCol=Activecell.Column

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com