Hide rows or columns in excel

Can’t seem to get the hide and unhide commands correct:

sheet.range(“2:9”).select_ … works just fine

sheet.selection.entireRow.hidden = false … does not work

VBA shows “Selection.EntireRow.Hidden = False”

anyone succeed at this ?

Forgive me asking , but did you mean

sheet.selection.entireRow.hidden = true ?

because setting a range to hidden = false if it is already visible wouldn’t do anything…

If you are trying to show already hidden rows and they do not appear, is the sheet protected in some way?

That particular commands is trying to unhide hidden rows. Then I’ll hide the rows again.

Nice catch tho . . .