Hi All
I'm sure I'm being stupid here. I'm looping through the rows of a table - when a cell in the row contains no date, I want to set the background color of the row - and I can't work out how!
Can anyone point out the obvius for me?
Ta
Si
I'm sure I'm being stupid here. I'm looping through the rows of a table - when a cell in the row contains no date, I want to set the background color of the row - and I can't work out how!
VBA Code:
For Each rowdata In appTable.ListRows
If rowdata.Range(1, 6) = "" Then
???????????
End If
Next
Ta
Si