Excel macro screen updating angela simmons dating prophet
Last question does the flickering screen appears after executing such code.
End With" instead of going through the whole "chain of command" to access the object.
then you need to turn on before writing the code for execution of msgbox or a userform popup.
What i do is i always turn it on once my work is done.
Obviously the screen updating is showing the changes between template & dumpfiles and showing the complex formating on each of the lists.
I have a macro thats currently taking 2 hours to create 400 files.