+ Reply to Thread
Results 1 to 5 of 5

Getting used range from worksheet as named range for specific columns

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    2,805

    Getting used range from worksheet as named range for specific columns

    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

  2. #2
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Türkiye
    MS-Off Ver
    2010 - 64 Bit
    Posts
    876

    Re: Getting used range from worksheet as named range for specific columns

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

  3. #3
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Türkiye
    MS-Off Ver
    2010 - 64 Bit
    Posts
    876

    Re: Getting used range from worksheet as named range for specific columns

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

  4. #4
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    2,805

    Re: Getting used range from worksheet as named range for specific columns

    thank you!!!

    Jacek

  5. #5
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Türkiye
    MS-Off Ver
    2010 - 64 Bit
    Posts
    876

    Re: Getting used range from worksheet as named range for specific columns

    You're welcome...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to print worksheet specific named range in footer for specific worksheet
    By *me* in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2019, 01:16 AM
  2. Adjust existing macro to pick up specific named worksheet and copy to named range
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-08-2017, 12:03 PM
  3. Get data from userform to input into specific worksheet with named range
    By Mark Dynes in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-17-2017, 12:18 PM
  4. Copy a specific row and a range of columns to next available row on another worksheet
    By monkey1184 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2013, 05:02 PM
  5. How to delete specific columns based on a named range of values from a worksheet
    By dronofrio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 10:56 AM
  6. CountA within specific columns of a named range
    By Golf Nut in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2012, 02:58 PM
  7. [SOLVED] create named range specific to worksheet
    By beliavsky@aol.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1