Hire Freelancers

Trouble shoot vba code to figure out why its creating a subscript out of range Error or opbject out of range error..

$10-30 USD

Completed

Posted

about 1 year ago

$10-30 USD

Paid on delivery

I have a file, wrote a macro and it keeps erroring out and not performing like i need it to. it gives me a subscript out of range error or object out range error. I need someone to help me get it figured out and i am hoping to resolve this in the next hour. see attached file.

Data Processing

Visual Basic for Apps

Project ID: 36228773

About the project

2 proposals

Remote project

Active 1 yr ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

Flag of INDONESIA

It is because you set the index of cells started on 0, not 1. This will keep error. There are a few ways for solving this: 1. Use keywords: on error resume next 2. Modify the code I will do for you. Which one you prefer? Best Regards, Khamid

$30 USD in 1 day

4.5

(48 reviews)

7.9

7.9

2 freelancers are bidding on average $35 USD for this job

I can help you with your file but it will take me the next 24 hours to work on it, if that suits you lets discuss the details

$40 USD in 24 days

5.0

(6 reviews)

2.6

2.6

Post a project like this

About the client

Flag of UNITED STATES

Anchorage, United States

5.0

2

Payment method verified

Member since Jul 9, 2010

Client Verification

Other jobs from this client

Extract unique data from excel dynamic table and total up quantity using Dynamic Drop down list as critera to search by

Custom Word Press Plugin needed

Trouble shoot vba code to figure out why its creating a subscript out of range Error or opbject out of range error.. - 19/03/2023 22:49 EDT

VBA Code to attach excel sheet(s) that have been copied from a workbook

Similar jobs

Advanced Excel & Word VBA Automation

Excel Macro Expert for Mac Compatibility

Modify Excel Macro for macOS

ChatGPT Excel VBA Debugging

£5-10 GBP / hour

Remote Recruitment Coordinator for Data Entry & Assistance

Excel Macro Guru-- small job

₹750-1250 INR / hour

Excel-Based Financial Analysis and Statements

$15-25 USD / hour

Executive Dashboard Creation with Power BI

Medical Data Entry Specialist Needed -- 2

$2-8 USD / hour

Data Extraction Pipeline for Data Cleaning -- 2

₹1500-12500 INR

PDF to Excel Data Entry

MS Active Directory Meta Data Capture

₹1000-1600 INR

Advanced Excel VBA Programmer Needed for Innovative Product

£18-36 GBP / hour

English Text Data Entry from Digital Files

₹12500-37500 INR

Text Content Migration Specialist

₹750-1250 INR / hour

Bakery Formula Costing Database -- 2

Excel Software for Automation & Visualization -- 2

₹1500-12500 INR

Google Document Into Word

$15-25 USD / hour

Excel Contact Export & Merge - 17/05/2024 17:14 EDT

₹750-1250 INR / hour

Enhance Reporting in VB6 Source Code

Post a project like this

Thanks! We’ve emailed you a link to claim your free credit.

Something went wrong while sending your email. Please try again.

Loading preview

Permission granted for Geolocation.

Your login session has expired and you have been logged out. Please log in again.