ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Know exact position of a cell in the Sheet (https://www.excelbanter.com/excel-programming/339227-know-exact-position-cell-sheet.html)

baldomero[_7_]

Know exact position of a cell in the Sheet
 

Hello, I would like to know if there is any way to know the exact
position in numbers of a given cell in the worksheet.

For example, given the address of a unique cell (that is $A$4, or R3C3,
or whatever it can be), how can I know it's position in numbers? I want
to make calculations on it given it's position, and so, I need its
coordinates on the Worksheet in numbers.


--
baldomero
------------------------------------------------------------------------
baldomero's Profile: http://www.excelforum.com/member.php...o&userid=25680
View this thread: http://www.excelforum.com/showthread...hreadid=401976


baldomero[_8_]

Know exact position of a cell in the Sheet
 

:eek: Oh my god, sorry, yes .Row and .Column...
...
...
...


--
baldomero
------------------------------------------------------------------------
baldomero's Profile: http://www.excelforum.com/member.php...o&userid=25680
View this thread: http://www.excelforum.com/showthread...hreadid=401976



All times are GMT +1. The time now is 08:10 PM.

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