Hello stevesunfold,
The variable PONUMBER appears to be a Range. I don't see in the code where this variable is set or declared. That's why you're getting the error. Use the Option Explicit statement as the first line of your module. This will tell you when a variable hasn't be declared.
Sincerely,
Leith Ross
Bookmarks