+ Reply to Thread
Results 1 to 4 of 4

Deleting a named range versus deleting a table

  1. #1
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    MS OFFICE 365 EXCEL, OUTLOOK, WORD, POWERPOINT
    Posts
    196

    Deleting a named range versus deleting a table

    Question: If I highlight a table and press the delete key it appears to go away. I'm sure the data is gone, but what about the table itself? The question is prompted by the behavior of named ranges. When you delete them the range is still defined and it still appears in the navigation box even if there is no data in the cells.

    The back story is that every day we import about five hundred lines of data. The import macro simply highlight yesterday's data and pressed the delete key. Then it opens the export data file and copy/paste the daily data dump.

    From these two columns I would like to create a dependent dropdown in two places from distinct information. I’ve been reading up and understand the process. But I have found three different methods to make it happen. Two of the three say you can do it with named ranges but they recommend you do it with tables. I know that when the macro pastes the data in the same place the named ranges will be populated again. I was just wondering if the tables feature behaved in a similar manner.

    Thanks. And, may this time of the year be great for you. I’m a Merry Christmas guy myself. But I understand that Christmas isn’t the only special holiday around this time of the month. However you view it I hope that what you see is what you wish for to see.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Deleting a named range versus deleting a table

    It's not 100% clear what you are asking.

    If you are using a table then you don't need named ranges and can use structured references to refer to the columns in the table.
    If posting code please use code tags, see here.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Deleting a named range versus deleting a table

    The named range will probably still work as even when you delete a range it will still be there albeit the contents of those and its surrounding cells may have changed.

    With a table it is slightly different as the dimension of the table may or may not change depending on how you clear the cells.

    This code snippet will delete the cells in the body of the table

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    MS OFFICE 365 EXCEL, OUTLOOK, WORD, POWERPOINT
    Posts
    196

    Re: Deleting a named range versus deleting a table

    OK. If I understand it the table can still exist even without data in the cells. Thanks.

+ 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. Deleting cells within a named range within a macro
    By Mr_Natural in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2017, 09:30 PM
  2. Deleting cells within a named range within a macro
    By Mr_Natural in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2017, 09:21 AM
  3. Deleting value from 1st cell effects named range
    By tanvi_kalra in forum Excel General
    Replies: 2
    Last Post: 03-26-2014, 03:22 AM
  4. Deleting rows in between a named range
    By shanecb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2013, 12:15 PM
  5. Adding rows to named range and deleting them
    By Djwill in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2012, 02:56 PM
  6. Deleting all rows in Named Table
    By LampCommandr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2011, 03:46 PM
  7. how do i maintain named range addressing after deleting row?
    By erp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-30-2005, 09:55 PM

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