listrow

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! For Each rowdata In appTable.ListRows If rowdata.Range(1, 6) = "" Then...

HI! I'm a beginner (at best) with VBA loops and would need to adjust data in Excel table rows, depending on a single column cell value. I want to loop through all rows for this table and adjust data depending on value in 3rd column ("Check"). If column "Check" value is 1, insert value "Disable"...

All I have a piece of code that creates a new row at the end of a table which i then reference as oNewRow. I am now trying to get a specific cell from a another worksheet, and place it in a certain cell in the oNewRow. Here is what i have tried thus far, to no avail oNewRow.Range.Cells(1...

For some reason, the VB compiler doesn't seem to be recognizing the ListRow type in my Subroutine. I've been developing the subroutine piece by piece, and it has been working fine, then, I started getting Compile error: "ByRef argument type mismatch" for a function call that was fine before...