With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
Attached is a workbook with some VBA code that ActiKnow previously prepared for me. The code works exactly as intended with just one exception. When I click the "REFRESH DATA" button on the "HOME" worksheet (this executes a macro that pulls in fresh data to the PowerPivot data model from a Microsoft Access database), I get several occurrences of the following error (Usually around 7 occurrences).
Error on Active Worksheet Change Event.
50290 = Method 'Intersect' of object '_Global' failed
When this error occurs, I simply click "OK" for each of the error dialogs that appear and the process ultimately completes and everything works as intended. I believe the problem has to do with code on the "PRODUCTIVITY" worksheet and/or the VBA module called "modMain".
This error doesn't appear to be negatively impacting other functions of the application, so what I need is simply for the error to not occur when the user uses the &q...
Sign in or Register to see more