How To Get A Named Range To Grow

[Minitman]

Greetings,

I have a named range that I keep adding to. I can increase the size
manually but I need for the range to increase automatically.

How is this done?

Any help would be appreciated.

TIA

-Minitman

 

[Tom Ogilvy]

Refers to: =Offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),1)

possibly

 

[Minitman]

Hey Tom,

Thanks.

Works like a charm.

-Minitman