Results 1 to 7 of 7

Macro for data tables in financial model slowing down excel

Threaded View

  1. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,556

    Re: Macro for data tables in financial model slowing down excel

    OK, here's the code:

    Option Explicit
    
    Sub sClearDataTable()
    
    With Sheets("Masterlease")
        .Range("N8:AC27").ClearContents
    End With
    
    End Sub
    
    Sub sLoadDataTable()
    
    With Sheets("Masterlease")
        With .Range("M7:AC27")
            .Table _
                RowInput:=Range("F14"), _
                ColumnInput:=Range("F15")
        End With
    End With
    
    End Sub
    
    Sub sLoadDataTable_Test()
    
    With Sheets("Masterlease")
        With .Range("M7:AC27")
            .Table Range("F14"), Range("F15")
        End With
    End With
    
    End Sub
    I'd suggest you move the buttons to the top of the sheet above the table, as in the attached updated workbook. I have assigned the macros to both sets of buttons, so have a play and see which you prefer.
    Attached Files Attached Files
    Last edited by TMS; 08-03-2021 at 07:28 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Financial model - cashflow help
    By j.mccartan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-27-2020, 10:14 AM
  2. Financial Model Not Working
    By adams2233 in forum Excel General
    Replies: 3
    Last Post: 04-16-2019, 08:13 AM
  3. Replace formulas that are slowing down Excel model significantly
    By helpmeplz_ in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-12-2018, 09:49 AM
  4. Similar Financial Forms throughout model
    By hlep in forum Excel General
    Replies: 0
    Last Post: 05-15-2012, 04:00 AM
  5. Excel question for financial model
    By kidflip in forum Excel General
    Replies: 2
    Last Post: 03-16-2011, 03:13 AM
  6. financial model
    By cassandra23 in forum Excel General
    Replies: 4
    Last Post: 12-24-2008, 12:20 AM
  7. financial model
    By sid_2007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2007, 08:32 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