Find Last Cell For A Named Range

[Minitman]

Greetings,

I need to make a named range that is constantly growing. Is there any
way to have the last used cell in a column be the bottom cell in a
Named range?

TIA

-Minitman

 

[JulieD]

Hi Minitman

yes, by using the offset function to create a dynamic range ... check out
Debra Dalgleish's website on this
http://www.contextures.com/xlNames01.html#Dynamic

Cheers
JulieD

 

[Peo Sjoblom]

One way

=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A),)

insert>name>define name, give it a name and in the refers to box put the
formula

 

[Minitman]

Hey JulieD,

That is exactly what I was looking for.

Thank You!

-Minitman

 

[Minitman]

Hey Peo,

Both you and JulieD came up with the same answer, and it was a good
one.

Thank you both for the fast reply.

It is much appreciated.

-Minitman