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
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