ExcelBanter - How To Get A Named Range To Grow

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How To Get A Named Range To Grow (https://www.excelbanter.com/excel-programming/341247-how-get-named-range-grow.html)

Minitman[_4_]

How To Get A Named Range To Grow

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

How To Get A Named Range To Grow

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

possibly

--
Regards,
Tom Ogilvy

"Minitman" wrote in message
...
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

Minitman[_4_]

How To Get A Named Range To Grow

Hey Tom,

Thanks.

Works like a charm.

-Minitman

On Tue, 27 Sep 2005 14:01:53 -0400, "Tom Ogilvy"
wrote:

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

possibly

--
Regards,
Tom Ogilvy

"Minitman" wrote in message
.. .
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

All times are GMT +1. The time now is 05:04 AM.