Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide rows.
I have a stock order form. I want to find a way to hide
rows containg items that do not need to be ordered. for example: A B 1 paper 2 2 ink 3 pens 4 4 staples Is there a macro that can filter out empty quantity celss and hide the whole row (rows 2 and 4 in this instance)? I appreciate your time and effort. Steve. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide rows.
Hi Steve
I would use Filter / Autofilter for this (goto "Data - Filter") and filter all 'non blanks# HTH Frank Steve wrote: I have a stock order form. I want to find a way to hide rows containg items that do not need to be ordered. for example: A B 1 paper 2 2 ink 3 pens 4 4 staples Is there a macro that can filter out empty quantity celss and hide the whole row (rows 2 and 4 in this instance)? I appreciate your time and effort. Steve. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide rows.
What do you want to do with the rows that are left visible. Do you want to
print them? Copy them? Just look at them? HTH Otto "Steve" wrote in message ... I have a stock order form. I want to find a way to hide rows containg items that do not need to be ordered. for example: A B 1 paper 2 2 ink 3 pens 4 4 staples Is there a macro that can filter out empty quantity celss and hide the whole row (rows 2 and 4 in this instance)? I appreciate your time and effort. Steve. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide rows.
The document is a fax form.
-----Original Message----- What do you want to do with the rows that are left visible. Do you want to print them? Copy them? Just look at them? HTH Otto "Steve" wrote in message ... I have a stock order form. I want to find a way to hide rows containg items that do not need to be ordered. for example: A B 1 paper 2 2 ink 3 pens 4 4 staples Is there a macro that can filter out empty quantity celss and hide the whole row (rows 2 and 4 in this instance)? I appreciate your time and effort. Steve. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide rows.
One way:
Say that Column B is the column that contains the criteria for hiding the rows. That is, you want to hide all the rows that are blank in Column B. Say your data goes from B1 to B50. Select B1:B50. Hit the F5 key (the GoTo key), click on Special at the bottom of the GoTo box. Click on the radio button for blanks. Click OK. All the blank cells in B1:B50 will now be selected. Run the following macro. It will hide all the rows that are blank in B1:B50. HTH Otto Sub HideBlankRows() Dim i As Range For Each i In Selection i.EntireRow.Hidden = True Next i End Sub wrote in message ... The document is a fax form. -----Original Message----- What do you want to do with the rows that are left visible. Do you want to print them? Copy them? Just look at them? HTH Otto "Steve" wrote in message ... I have a stock order form. I want to find a way to hide rows containg items that do not need to be ordered. for example: A B 1 paper 2 2 ink 3 pens 4 4 staples Is there a macro that can filter out empty quantity celss and hide the whole row (rows 2 and 4 in this instance)? I appreciate your time and effort. Steve. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
Macro to hide rows | Excel Discussion (Misc queries) | |||
hide rows with macro | Excel Discussion (Misc queries) | |||
macro to hide rows | Excel Discussion (Misc queries) | |||
Macro to hide rows | Excel Programming |