Named Range Query

[tyija1995]

Hi all,

Stumbled across this issue when trying to help someone else on here,

Is it possible to name a range as a cell reference? My assumption is no this is not possible but worth an ask.

E.g. I want to name the range N2:N3 as "h1" but that refers to a cell so it renders impossible right? There isn't a way to bypass this with brackets or anything?

Thanks!

 

[mole999]

https://www.mrexcel.com/forum/excel-questions/56616-namining-conventions-named-ranges.html

 

[Fluff]

You could name it with an underscore ate start _h1

 

[tyija1995]

Thanks for the link mole - will take a read.

Thanks Fluff - this idea of an underscore crossed my mind after posting this, so I have used it to reference the named range using INDIRECT with the preceeding underscore !

 

[Fluff]

You're welcome & thanks for the feedback