+ Reply to Thread
Results 1 to 3 of 3

Horizontally expand the range name into a Table

  1. #1
    Registered User
    Join Date
    07-28-2015
    Location
    Buenos Aires, Argentina
    MS-Off Ver
    2013
    Posts
    0

    Lightbulb Horizontally expand the range name into a Table

    Hello everybody, this is my first time here.
    When we have a named range, and then become as Table, records that are incorporated under the last row of the table will be included in the named range. However, columns added to the table, will not be included in such a named range. Is there any procedure to include the new columns to the named range?
    I will appreciate any comments.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello Pityon,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    08-31-2015
    Location
    United States
    MS-Off Ver
    Mac 2011
    Posts
    12

    Re: Horizontally expand the range name into a Table

    Hi,

    This is the introduction sub forum and those individuals that can help you would most likely not be looking here. Create a thread with your question in the below sub forum link then you would definitely get the best answer.

    http://www.excelforum.com/excel-formulas-and-functions/
    If I have helped, click on the star below the post

+ 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. Replies: 7
    Last Post: 04-18-2014, 12:29 PM
  2. Expand a table by adding rows ( table feature 2007 and later)
    By Pepe Le Mokko in forum Excel General
    Replies: 3
    Last Post: 08-13-2013, 05:12 AM
  3. Displaying data horizontally after a table filter
    By martinpgibson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-11-2013, 06:16 PM
  4. [SOLVED] Excel 2007 : Horizontally Scrolling Table
    By HangMan in forum Excel General
    Replies: 2
    Last Post: 07-09-2012, 01:14 PM
  5. Auto Expand Table based on Range of Date stated
    By forest06 in forum Excel General
    Replies: 0
    Last Post: 06-27-2012, 01:28 PM
  6. Searching a table vertically and Horizontally
    By smokeydawson555 in forum Excel General
    Replies: 3
    Last Post: 06-29-2009, 11:55 PM
  7. Replies: 1
    Last Post: 07-07-2005, 09:05 AM

Tags for this Thread

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