| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locate cell in Named Range
Thanks everyone!
"Tom Ogilvy" wrote in message ... sorry, sent this to you email: If it is contiguous (a single area range) set rng = Range("ABCD") rng.rows(rng.rows.count).offset(1,0).EntireRow.Ins ert -- Regards, Tom Ogilvy "Steph" wrote in message ... Anyone know how to programatically find the bottom left cell of a named range? I need to find that cell, and insert an entire row beneath it. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locate a cell value within a range and return its reference | Excel Discussion (Misc queries) | |||
| 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) | |||
| named cell range | Excel Worksheet Functions | |||
| Getting a named range from a cell value | Excel Worksheet Functions | |||
![Steph[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
