Results 1 to 6 of 6

Clear an Excel table with a Macro

Threaded View

  1. #3
    Registered User
    Join Date
    03-13-2019
    Location
    Milwaukee, WI
    MS-Off Ver
    2016
    Posts
    4

    Re: Clear an Excel table with a Macro

    Okay, Good suggestion. I copy the data in columns A:N from a large database. It usually is several hundred rows of data. Columns O:R are calculated. I run a quick macro to clean the data and copy it then I post it in the page for that institution. All I am looking for here is a macro to clear this table called "TableRadBadges" so it is ready for my next import. I do not want it to delete the formulas in columns O:R or the titles. I was able to find information to do this for a range but not for data in Excel table format.
    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. Macro to Clear Cells and form a table out of it
    By Nikhil76 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2018, 08:19 PM
  2. Replies: 9
    Last Post: 09-05-2017, 06:14 PM
  3. Clear List Macro for Data Validation, Multiple Lines in table
    By gedwards913 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2014, 04:42 PM
  4. Pivot Table Macro Help - Clear ColulmnFields
    By jtwusmc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2013, 11:25 AM
  5. Clear Word Table Row from Excel VBA
    By natefarm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 06:07 PM
  6. Macro to clear all filters in a table
    By quantumag in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2013, 05:39 PM
  7. Macro to clear then reinsert pivot table datafield
    By Fullam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2006, 07:40 AM

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