Results 1 to 9 of 9

How to stop a table from being deleted when setting a range?

Threaded View

  1. #7
    Registered User
    Join Date
    05-29-2015
    Location
    Croatia
    MS-Off Ver
    2013
    Posts
    19

    Re: How to stop a table from being deleted when setting a range?

    Quote Originally Posted by sktneer View Post
    Maybe you can try something like this.....
    ActiveSheet.ListObjects("Tablica1").ListRows.Add
    Worksheets("Sheet1").Range("A2:B2").Value = Worksheets("Sheet1").Range("A1:B1").Value
    No, this doesn't work because it resizes the table (adds another row). The table needs to keep its original dimensions. After running this code, the table is in range A2:B3 instead of the original range A2:B2.
    It partially worked because the table wasn't deleted after running the code.
    Last edited by Mutak; 07-12-2016 at 08:13 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Active X Controls Stop working even after .exd files were deleted
    By rmeckm2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-06-2015, 11:33 AM
  2. Replies: 0
    Last Post: 11-19-2012, 03:55 AM
  3. Stop running till the columns are deleted!
    By casperzero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2012, 02:19 AM
  4. Replies: 6
    Last Post: 06-12-2012, 04:36 PM
  5. Formulas change when column/row is deleted... how can i stop that?
    By RNiner in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-11-2006, 06:03 PM
  6. How to stop CommandButtons being deleted as pictures in code??
    By Corey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-15-2006, 07:25 AM
  7. [SOLVED] Setting Range in Pivot Table
    By Dhiraj in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-14-2005, 09: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