Forum Discussion
Macro has to be run twice
I'm working on an excel file that was designed by someone else. I am only new to VBA. I run the macros previously created to import sheets and data. I then run my simple macro to update three cells t...
Hi Darren
it's hard to say without seeing the original file
I can assume what happened to me once, it may need more time to access the hard drive (file) so you will have to put a delay in the code
Application.Wait(Now + TimeValue("0:00:10"))
try and let me know is it working