If cells in rows 1 and 2 are merged, hiding either row 1 or 2
will hide both row 1 and 2. There is no way around this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Marijan Glavac" wrote in message
...
Hi,
I have situation like this :
In first column I have merged cells ( Merged cells
=A1,A2).Colum B haven't
merged.I try thruog code hide row 2 but I hide row 1 and row
2.Here is my
code :

I=2
Row(i).Select
Selection.EntireRow.Hidden = True

Where is my mistaque ?
Thanks in advance