my bad-had the resize method wrong
![]()
If Application.WorksheetFunction.Count(cell_Check.Offset(, -1).Resize(, 4)) = 4 And Application.WorksheetFunction.CountIf(cell_Check.Offset(, -1).Resize(, 4), ">0") = 4 Then
my bad-had the resize method wrong
![]()
If Application.WorksheetFunction.Count(cell_Check.Offset(, -1).Resize(, 4)) = 4 And Application.WorksheetFunction.CountIf(cell_Check.Offset(, -1).Resize(, 4), ">0") = 4 Then
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks