First-time poster here. I used to have a ton of experience with Java and C# but now my job calls for VB scripts in excel. Probably an assignment error or logic error but here's the code :
basically what im doing is i have two workbooks "New Dashboard" and "Book1". I search column A in Book1 for HELLO, and then i use the row it was found in to grab a value "HrsVal". I take that value and i put it "New Dashboard". I then do the same for every sheet. It seems to fail in my second loop in the 2nd sheet. Error says "Overflow".
Thanks![]()
Please Login or Register to view this content.
Bookmarks