Hide row from VBA

M

Marijan Glavac

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
 
C

Chip Pearson

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
 
E

Ecco

Hi

This works for me.

I = 2
Columns(I).Select
Selection.EntireColumn.Hidden = True

Regards Ecc
 
N

Nigel

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
 
D

Dave Peterson

A minor modification of your code worked for me in xl2002.

i = 2
Rows(i).Hidden = True

but this:
I=2
Rows(i).Select '<--added S to Row(s)
Selection.EntireRow.Hidden = True
Click to expand...

behaved the way you described, too. Since you selected that row, it included
the merged cells.


What version of xl are you using?

Merged cells behavior has changed through different versions of excel.

I think that this is the way xl97 behaved with merged cells. And even the code
that worked for me wouldn't do what you wanted in xl97.
 
Top