176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

VBA Code Adjustment
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Apr 4, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Mon, Mar 25, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Hourly Rate: Not Sure
  • Hrs/wk: Not Sure | Duration: 1-2 weeks
  • Work View™ Payment Protection
  • U.S. freelancers must have W9
Sign in to view client's details

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

Desired Skills
MySQL Administration, HTML, PHP
Job ID: 39484600
Proposals
Hourly Rate: Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
I have experiences in various domains like Accounting, Inventory and ERP, CRM,Customize software development using .net technology as well as...
7
  |  
 5.0   |  Private   |  8 Jobs
Bid ID: 39528012  |  Submitted: Mar 26, 2013 13:53 ET 
Proposal SEALED

Winner
Rated top 1 percentile in Excel/VBA and Analytical capabilities, we are expert programmers and trainers with >500+ projects successfully delivered...
11
  |  
 4.9   |  $88,309 Earnings   |  63 Jobs
Bid ID: 39508760  |  Submitted: Mar 26, 2013 05:13 ET 
$21.45/hr

Udhaya rohini Alagarsmy Kumar...      
Udhaya rohini Alagarsmy Kumaraguru's identity has been verified.  Learn More
 India  |  
Hi...This is Udhaya from Bangalore, India...I am a BI developer. SSRS report creation is an interesting job to me. I have worked in various...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 39507253  |  Submitted: Mar 26, 2013 04:29 ET 
Proposal SEALED

 India  |  
Over the last few years, Ideal Solutions has embarked on the competitive IT environs with an innate ideology of providing end-to-end customized IT...
4
  |  
 5.0   |  Private   |  3 Jobs
Bid ID: 39496337  |  Submitted: Mar 25, 2013 22:21 ET 
Proposal SEALED

 Australia  |  
AREAS OF SPECIALIZATION: Macros/VBA (MS Excel, Word, Outlook), Google Docs scripting, Microsoft Visual Studio Tools for Office (VSTO), MS Access,...
6
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 39495151  |  Submitted: Mar 25, 2013 21:35 ET 
Proposal SEALED

 United States  |  
Automated Solutions Provider Systems Analysis/Programmer The primary skill I will be offering on ELance is my indepth knowledge of and...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 39491090  |  Submitted: Mar 25, 2013 18:40 ET 
Proposal SEALED

 United Kingdom  |  
Freelance Business Programmer / Developer - Excel, VBA, Access, Engineering Apps - Over the past 20 years, I've developed an extensive range of...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 39489841  |  Submitted: Mar 25, 2013 17:54 ET 
Proposal SEALED

 Poland  |  
I have many years of experience in the financial sector. I'm currently working with well-known Insurance Company where I'm responsible for group...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 39488138  |  Submitted: Mar 25, 2013 16:57 ET 
Proposal SEALED

 India  |  
We cater the needs of different industrial fields with customized solutions that include e-commerce, e-learning, content management system (CMS),...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 39486129  |  Submitted: Mar 25, 2013 16:05 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »