Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referring to specific cell in named range in Excel formula | Excel Worksheet Functions | |||
Finding the position of the i-th non blank cell in a vertical range | Excel Worksheet Functions | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Position of a cell in a range | Excel Worksheet Functions |