Merged Cells Causing Problem in Macro
 

I have an excel spreadsheet that has cells merged between rows, for example
cells C5 and C6 are merged and Cells C8 and C9 are merged. I tried writing
code to hide rows 6:6 and 9:9, but when I run it, it hides all rows 5, 6, 8,
and 9.

How can I get it to only hide rows 6 and 9?

When you hide the rows from the spreadsheet it works fine, you can select
the row and hide it and the contents of the merged cells remains in the upper
of the two rows in the range. But from a macro it hides both rows.

Merged Cells Causing Problem in Macro
 

Other than the fix of "unmerging" cells before selection and Hiding

"Erica" wrote:

I have an excel spreadsheet that has cells merged between rows, for example
cells C5 and C6 are merged and Cells C8 and C9 are merged. I tried writing
code to hide rows 6:6 and 9:9, but when I run it, it hides all rows 5, 6, 8,
and 9.

How can I get it to only hide rows 6 and 9?

When you hide the rows from the spreadsheet it works fine, you can select
the row and hide it and the contents of the merged cells remains in the upper
of the two rows in the range. But from a macro it hides both rows.

Merged Cells Causing Problem in Macro
 

try running your code but instead loop from bottom to top
--
GNN


"Erica" wrote:

Other than the fix of "unmerging" cells before selection and Hiding

"Erica" wrote:

I have an excel spreadsheet that has cells merged between rows, for example
cells C5 and C6 are merged and Cells C8 and C9 are merged. I tried writing
code to hide rows 6:6 and 9:9, but when I run it, it hides all rows 5, 6, 8,
and 9.

How can I get it to only hide rows 6 and 9?

When you hide the rows from the spreadsheet it works fine, you can select
the row and hide it and the contents of the merged cells remains in the upper
of the two rows in the range. But from a macro it hides both rows.