i suspect it is because I use select/activate, copy and paste from different other worksheet which is seen as a LIBRARY. I wonder if it is possible to save the library in XLA and then call the objects from XLA file using EXCEL VBA.
Is it a better way of dealing the flickering screen.
I've got a listbox which populates a second listbox from cells on a hidden worksheet which is done through macros.
If you're not already familiar with forums, watch our Welcome Guide to get started.
I spend a lot of time in VBA, so new features in Excel don’t generally inspire me.
File Dialog(mso File Dialog File Picker) If doc To Open.
Range Dim o Frm As frm Progress Dim Portion Done As Double On Error Go To Err_Exit str Text To Insert = "Annual bonus rates for the last five years" str Text To Find = "Discharge Pack" Set doc To Open = Application.