CODEWITHSUNDEEP
excelvbashow-hide
RatherB
RatherB

Reputation: 1

How to Unhide rows greyed out below a table

All rows below a table are not shown (grey background only), and the row numbers are not shown.

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;

debug.print ThisWorkbook.Sheets("Sheet1").Rows(lastTableRow+1).Hidden

continues to return true and the row remains hidden.

Hiding and unhiding works as expected for rows in the table. The rows clearly exist as values can be added and retrieved.

Upvotes: 0

Views: 69

Answers (0)

Related Questions