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.
Call code for referencePlease Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks