excel macro run time error '1004'- Application defined or object defined error

**kmadan** · 06-12-2014, 11:03 AM

Hi,

My requirement is to write a VBA code in Excel 2010 to merge the multiple excel files into one master excel file. I have written the below code-

Please Login or Register  to view this content.

I am new to VBA programming. So, Can anyone please help me here? This is urgent.

Thanks,
Karan

**Tinbendr** · 06-13-2014, 08:54 AM

Without data, it's difficult to determine, but this might be the cause.

Please Login or Register  to view this content.

The 'Rows' isn't fully qualified.

Please Login or Register  to view this content.

(LR1 + LR2 - 4) can't be less than LR1.

**kmadan** · 06-16-2014, 09:51 AM

Hello Tinbendr,

Thanks for your reply. I made the change you suggested but unfortunately its not working. I am getting the same error.

The excel files that i am trying to merge contains mostly one row of data, and always two columns.

Really Appreciate your time in this.

Thanks,
Karan

excel macro run time error '1004'- Application defined or object defined error

LinkBack

Thread Tools

Rate This Thread

Display

excel macro run time error '1004'- Application defined or object defined error

Re: excel macro run time error '1004'- Application defined or object defined error

Re: excel macro run time error '1004'- Application defined or object defined error

Thread Information

Users Browsing this Thread

Similar Threads

Run time error 1004: Application-defined or object-defined error in long IF VBA formula

[SOLVED] Run time error 1004 Application-Defined or Object-Defined Error - Placing data into next e

[SOLVED] Macro causes Run time error 1004 Application defined or object-defined error

[SOLVED] run-time error '1004' application-defined or object-defined error - Excel 2007

Macro - Run-time Error '1004': Application defined or object defined error

Bookmarks

Bookmarks

Posting Permissions