Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide row from VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide row from VBA
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide row from VBA
Hi
This works for me. I = 2 Columns(I).Select Selection.EntireColumn.Hidden = True Regards Ecc -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide row from VBA
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide row from VBA
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 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. Marijan Glavac wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you hide/un-hide the grid lines | Excel Discussion (Misc queries) | |||
Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
How do I hide hide #REF! in Excel | Excel Discussion (Misc queries) | |||
Hide Unhide Hide again | New Users to Excel | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |