Results 1 to 26 of 26

Thread: [RESOLVED] [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

Threaded View

  1. Jan 13th, 2014, 07:48 AM #19
    ammu
    ammu is offline

    Thread Starter
    Lively Member
    Join Date
    Nov 2013
    Posts
    81

    Re: [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

    Dear Sir,

    I am getting the following error "Run-time error '1004' Application-defined or object defined error and highlighting the following line of code
    "newb.sheets(shts(s)).Range("a1").Resize(, cols).Value = wb.sheets(shts(s)).Range(heds(s)).Value"

    When I skip the above line of code and move to the next one it is showing another error "Run-time error '9' script out of range" and highlighting the following line of code
    "newb.sheets(shts(s)).Range("a" & rw(s)).Resize(rws, cols).Value = wb.sheets(s).Range(Rng(s) & rws - 1).Value" Please help me what to do.
    Last edited by ammu; Jan 13th, 2014 at 07:52 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width