All rows below a table are not shown (grey background only).
The sheet is not protected. Any ideas how to unhide?
I can change the hidden status of those rows using
ThisWorkbook.Sheets("Sheet1").Rows(lastTableRow+1).Hidden=false
with no error message, and
debug.print ThisWorkbook.Sheets("Sheet1").Rows(lastTableRow+1).Hidden
returns false but the row remains hidden.
Hiding and unhiding works as expected for rows in the table.
1