#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Dynamic Named Range

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make a dynamic named range Arup C[_2_] Excel Discussion (Misc queries) 4 December 31st 07 12:17 PM
using a dynamic named range in a VLOOKUP Dave F Excel Discussion (Misc queries) 3 January 19th 07 08:38 PM
Dynamic named range & Offset fastballfreddy Excel Discussion (Misc queries) 1 May 4th 06 09:00 AM
Dynamic Named Range bountifulgrace Charts and Charting in Excel 1 April 6th 06 08:39 PM
dynamic named range function MJB Excel Worksheet Functions 1 August 5th 05 05:56 AM


All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"