Hi All,
I'm not a programmer by any means but am trying to work on a project. I have a sub created that finds the last row, puts a thick border line below it and puts the next business day in the start of the next row. On the sheet I created it in, it works without an issue, however, when I try to put it in other sheets in the same workbook, it errors out with a mismatch error. I have tried my best to solve the issue but after hours of googling, I still can't figure it out. It shows an issue with the last line "Range("B"..." but I can't figure out the issue and why it will work on the original sheet I created and not the copied one. I have even tried copying the entire sheet and it does not work. The code is in "ThisWorkbook." There is another code running on each page that just inserts the time when text is entered into another cell. I don't think it effects the code below, but I have included it just in case. Any help would be greatly appreciated. Thanks!
Other code on each sheet:
Bookmarks