Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Everyone here has been so helpful, I very much appreciate it and
trying to return the favor when I can. I have a question about constructing named ranges. If I have the following formula: (MID(H$5,3,2)) - how can I convert that to a named range? I understand how to construct a formula as a named range, but what I am not sure about is how to keep the 'dynamic nature' of the H$5 part? I will be copying the formula from cell and need it to update appropriately. Thanks. v/r Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make a dynamic named range | Excel Discussion (Misc queries) | |||
using a dynamic named range in a VLOOKUP | Excel Discussion (Misc queries) | |||
Dynamic named range & Offset | Excel Discussion (Misc queries) | |||
Dynamic Named Range | Charts and Charting in Excel | |||
dynamic named range function | Excel Worksheet Functions |