Deleted row, now it is giving problems with merged cells

[keis386]

Hi,

I deleted a row, how is it possible to get the row back?

the rows are now:

65
66
68
69
70

67 is missing. I have merged cells in my sheet. So it is really annoying if I am copying.

[tom1977]

Maybe You have hidden this row by mistake? Try this

Sub aa()
Rows.Hidden = False
End Sub

[TMS]

What can I say? Don't ever used merged cells.

If you have not saved or closed the workbook, you might be able to use Undo.

Failing that, you will probably need to re-constitute the row, perhaps from a backup or saved copy.

I tend to make regular copies of anything I am working on. Do you?

Regards, TMS

[TMS]

@tom: why a macro? It would be just as easy to do that manually. Easier, I suspect.

[tom1977]

@TMShucks
to unhide all rows beside I like macros very much

[TMS]

Fair enough ... but you could just type rows.hidden=false in the Immediate window.

Or click on the intersection of the row and column headers to select all and choose Format | Hide & Unhide | Unhide rows

Seems a macro is a bit of overkill and then you'd have to remove the module if there was no other need for macros in order to save the file (given the profile is 2007).

But, whatever, I won't lose sleep if it does the job.

[tom1977]

@TMShucks
I know I know
I have to tell You that my adventure with VBA started from such tiny code Maybe someone else will infect with VBA like me
regards and good luck