Something very strange happened. At one point this was working and all of a sudden now I get an error. The issue is fm and sm, when the debug is on, fm = Empty and sm = Empty Therefore tval = Empty the error occurs at line 34 ; tval = WorksheetFunction.Sum(ws.Range(ws.Cells(fm, 11), ws.Cells(sm, 11)))
Please Login or Register to view this content.
Last edited by YuriyBaron; 05-09-2018 at 03:41 PM.
Would be easier to diagnose the issue if we could see the workbook.
Any chance you could attach a desensitized version?
BSB
Unfortunately, the file is too large with sensitive information. Everything is also connected to SQL.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks