I've hidden rows in an Excel spreadsheet, and now want to delete them.
However I can't find a way to do this. Any advice ?

Select the rows before and after the hidden rows, and right click. Select
Unhide. They will be restored. You can then delete them as you would any
other row.

"Ian@DSL" wrote:

> I've hidden rows in an Excel spreadsheet, and now want to delete them.
> However I can't find a way to do this. Any advice ?

I assume that your subjets was going to say "without restroring the row" but
it has been truncated. If that is what you want try this Macro:

Sub DeleteIt()
For rRow = 200 To 1 Step -1
' Change the 200 to your highest row number
If Cells(rRow, 1).EntireRow.Hidden = True Then
Cells(rRow, 1).EntireRow.Delete
End If
Next rRow
End Sub

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


"Ian@DSL" <Ian@(E-Mail Removed)> wrote in message
news:27995B1C-909A-4AEE-B193-(E-Mail Removed)...
> I've hidden rows in an Excel spreadsheet, and now want to delete them.
> However I can't find a way to do this. Any advice ?
>