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
for a macro that can select only the visible cells.