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...

Macros & VBA

VBA

Tomasz Kocur

Brass Contributor

Apr 11, 2018

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

Deleted

Apr 11, 2018

Thanks for the reply.

That doesn't seem to solve the problem.

I have two buttons on the macro, One runs all of the previously created macros and fills the excel with data from different sheets that it imports, leaving only three cells with #REF.

When I click the second button, It fills the three cells but changes cells previously containing data to #REF.

I click the first button again and now everything has the correct data and I don't have any cells containing #REF.

I am unable to share the workbook.

I hope that my explanation in this reply helps you to understand my problem. Thanks again for your help.

Forum Discussion

Macro has to be run twice