+ Reply to Thread
Results 1 to 4 of 4

Screen turns white & tables behaving differently

  1. #1
    Registered User
    Join Date
    12-01-2016
    Location
    Birmingham, AL
    MS-Off Ver
    standard 2016
    Posts
    8

    Screen turns white & tables behaving differently

    Hello,

    I have a sub that functions properly. However, the screen turns white for a bit. I would like any advice on the inefficiencies of this block and if there is a way to speed up (perhaps an array) and/or eliminate the white screen. Basically adding 12 rows to 11 different tables. There is another column outside of table that i'm inserting 12 cells and auto filling a formula.

    Another specific question i have is... The first column of every table is filled with dates. When i expend the "Mast" table it autofills the date, picking up where the last date left off. But for some reason with the other tables, i've had to code a .autofill line in order to drag the dates down to the 12 new rows? Any reason why the "mast" table behaves differently than the other 10?

    fyi - This will eventually be call from another sub.

    Please Login or Register  to view this content.
    Call code for reference
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Screen turns white & tables behaving differently

    You could try to add a DoEvents statement after the tbl.ListRows.Add statement.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Registered User
    Join Date
    12-01-2016
    Location
    Birmingham, AL
    MS-Off Ver
    standard 2016
    Posts
    8

    Re: Screen turns white & tables behaving differently

    No dice TsJallie, thanks though.

  4. #4
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Screen turns white & tables behaving differently

    Can I have a look at yr workbook?
    Stripped of any sensitive data of course.

+ 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. [SOLVED] Ranges with same address behaving differently with offset
    By Pauleyb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-08-2018, 12:09 PM
  2. [SOLVED] Macro behaving differently depending on how it is called
    By louiserace in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-13-2016, 09:53 AM
  3. [SOLVED] VBA code behaving differently when stepping
    By Durarara in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2016, 05:20 PM
  4. [SOLVED] 2 copies of Excel 2010 behaving differently.
    By JennyW1983 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2015, 04:36 AM
  5. Replies: 9
    Last Post: 07-17-2015, 04:08 PM
  6. [SOLVED] Mail hyperlink turns white / cant paste directly
    By tis1337 in forum Excel General
    Replies: 4
    Last Post: 11-21-2012, 01:02 PM
  7. White text turns red or blue...
    By tawnyrochelle in forum Excel General
    Replies: 1
    Last Post: 04-23-2010, 01:28 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