Hidden rows
There
is no “select only visible rows” command. Selecting a block of
cells with hidden rows and deleting will delete the hidden rows as
well. Work-around: select each visible row manually before deleting.
See IannzGotoSpecial.sxc available from
https://homepages.paradise.net.nz/hillview/OOo/
for a macro that can select only the visible cells.
