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 ?
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 . . .