Getting used range from worksheet as named range for specific columns

[jaryszek]

Hi Guys,

i want to create named range where every time when i will refer to this named range i will get only used range.
I want to use whole worksheet and columns from A to E.

So example:

i have data filled in worksheet "Sheet1" in range A1:E100 so these should be my named range. Only this not empty cells after used range.

How can i do this using formula?

Best,
Jacek

[Haluk]

You can define a dynamic range like shown in the image below.

The formula referring to the named range "myTable" is:

Please Login or Register  to view this content.

Note that, you need to change ; with , depending on your regional settings

[Haluk]

Or, you can convert your data range to a Table and use this dynamic table as in the image below;

[jaryszek]

thank you!!!

Jacek

[Haluk]

You're welcome...