hi Marijan

If the row or colum contains merged cells then they will be hidden, but if
you merge across column for row hide or merege across rows for column hide
then all rows are column will be hidden.

Your code should read

Rows(i).EntireRow.Hidden = True

Cheers
Nigel

"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