Macro randomly fails

[Danny318]

I have a macro that usually works fine but lately it's been randomly failing on different tabs. The macro essentially just copies and pastes data from one sheet to another and then stops on tab called "dashboard" for viewing. Getting an error code saying "Invalid Forward Reference, or reference to uncompiled type". Why would it work for days in a row and then all of sudden fail? When we resurrect an older version of the source spreadsheet, the macro starts working again. Please let me know if you need more information. Help is appreciated!

 

[BSALV]

hello,
you 'd avoid to use select, that slows down the macro and has no added value.
I see a refreshall (bizar, without capitals) in front), so just a guess, add a "DoEvents" just in front and just behind that "Refreshall"-line.

Activesheet.paste

Doevents
activeworkbook.refreshall
Doevents

Sheets("Dashboard").select

 

[Danny318]

hello,
you 'd avoid to use select, that slows down the macro and has no added value.
I see a refreshall (bizar, without capitals) in front), so just a guess, add a "DoEvents" just in front and just behind that "Refreshall"-line.

Activesheet.paste

Doevents
activeworkbook.refreshall
Doevents

Sheets("Dashboard").select

Thanks! Are you saying just drop the word "select"? We use that command to tell the macro to move from one tab to another. We have several tabs that we paste data into.

 

[BSALV]

To copy from range1 to range2, you don't need to select and the macro runs quicker
In the most simple way it's like this
range("A1:C10").copy range("AA1")
see VBA Copy Range to Another Sheet + Workbook

 

[andro02351]

@BSALV Useful advice as that was about not needing to select, it wasn't actually responding to the question. @Danny318 Did the macro start working again after you did as BSALV suggested, or, something else?