dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,375
- Office Version
- 365
- 2016
- Platform
- Windows
I have some code that copies data to other sheets depending on various options that are selected. This is part of my code that is working:
If I remove the comments in the tblrow.rowcolor lines, I get the error of object doesn't support this property or method. What is the correct syntax to set the row colour?
Code:
Select Case tblrow.Range.Cells(1, 6).Value
Case "Yir"
DocYearName = tblrow.Range.Cells(1, 37).Value
'tblrow.RowColor = -65383
Case "Ang Wes", "Ang Riv"
DocYearName = tblrow.Range.Cells(1, 37).Value
'tblrow.RowColor = 0
Case Else
DocYearName = tblrow.Range.Cells(1, 36).Value
'tblrow.RowColor = 0
End Select
If I remove the comments in the tblrow.rowcolor lines, I get the error of object doesn't support this property or method. What is the correct syntax to set the row colour?