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".
ThanksPlease Login or Register to view this content.
Bookmarks