Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
How to create table of cell names with the name's cell address | Excel Discussion (Misc queries) | |||
How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) |