dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,375
- Office Version
- 365
- 2016
- Platform
- Windows
What variable has not been set in this code?
Code:
Sub cmdNot_Accept_click()
Dim DocYearName As String
Dim ans As String
Dim tbl As ListObject
Dim tblrow As ListRow
Set tbl = ThisWorkbook.Worksheets("Costing_tool").ListObjects("tblCosting")
If ActiveCell.EntireRow.Cells(1, 1).Value = "" Or tblrow.Range.Cells(1, 5).Value = "" Or tblrow.Range.Cells(1, 6).Value = "" Then
MsgBox "The Date, Service or Requesting Organisation has not been entered for every record in the table"
Exit Sub