If it's jumping to code there's usually a runtime error. I'm guessing this line: Set wb = Workbooks("") is the problem.
What version of excel are you using?
2010..... Do you think it's the file name? Maybe i am entering it wrong? Do you include the "xlsx"?
Also, i messed up in copying that code. actual code in the beginning is:
PHP:
Dim iRow As Long
Dim wb As Workbook
Set wb = Workbooks("Completed Seals 2012")
Dim ws As Worksheets
Set ws = Worksheets("Sheet1")
Last edited: