Growing Named Range

EricL

New Member
Joined
Sep 9, 2002
Messages
15
Hi all, Great boards.
I tried to find this in old post but wasn't seeing it in first 100 so thought I would ask.
I am looking to have a formula in my define Named range that can grow as I add things.
I have a table and as it is its named range is
=Sheet1!a1:z100
Now if I insert a row it should adjust its self in the named I believe. What I would like is for it to just grow if I add row.
I thought a formula like
=sheet1!a1:z and counta(z:z)) to get last number would work, but it doesn't. Would this be better done in VBA?
I want to be able to grow the table in both in rows and columns.

Thanks !

Eric
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
i've just changed the range to a dynamic one and now it won't come up as an available column....any ideas?
 
Upvote 0

Forum statistics

Threads
1,223,196
Messages
6,170,670
Members
452,346
Latest member
jaimesegurapena

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top