Posts by yoojrim

    Hello, Can someone please help?
    I am a little frustrated because this code did work just fine before I copied the code to another spreadsheet. The new spreadsheet still has the same number of tabs and tab names so I am not sure why it is not working.

    I am trying to copy contents from multiple spreadsheets into one main spreadsheet. I CAN copy from the first tab of multiple spreadsheets into the main one. That works fine (sub Overdraft_MECH). But when I run sub Overdraft_NCCS, that's when I get the out of range error message. Can someone please help?
    Out of error essage happens in sub O_2.