ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to get the address of a cell (https://www.excelbanter.com/excel-worksheet-functions/106850-how-get-address-cell.html)

Latch

How to get the address of a cell
 
First of all please apologize for my poor english...Im more comfy in french.

My question is this:

I create a function that use only one argument :

Function Score(arg1)
(...)

How can I get the address, the row and the column of arg1?

Thanks in advance for your answer

Dave Peterson

How to get the address of a cell
 
If arg1 is a range

arg1.row
arg1.column
arg1.address

may help.

Latch wrote:

First of all please apologize for my poor english...Im more comfy in
french.

My question is this:

I create a function that use only one argument :

Function Score(arg1)
(...)

How can I get the address, the row and the column of arg1?

Thanks in advance for your answer

--
Latch


--

Dave Peterson


All times are GMT +1. The time now is 04:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com