How to get the position of a cell in Excel named range?
Alan
Try For each ce in range("a1:a5") msgbox ce.address next ce This will loop through the cells a1 - a5 and show the address. Tony -----Original Message----- Hi Groups, I'd like to know if someone could show me how to get the position (col, row) of a cell in excel named range. What I need to do is: I will need to loop through a named range to find a particular cell by value, once I found it, I need to know the position of that cell. I'm doing this with C#, but any VB code would be help too. Thanks!. . |
All times are GMT +1. The time now is 02:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com