Results 1 to 9 of 9

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

Threaded View

  1. #3
    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?

    The problematic part of code is part of a bigger project I'm working on and I can't paste the whole code here.
    I've excerpted this line as an example and the problem persists when only this line is present, meaning that the problem is not due to other parts of the code.

    The workbook with the example is in the attachment. Notice how the table in the cells A2 and B2 disappears after clicking the CommandButton1 button.
    Attached Files Attached Files

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