| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I build "hide a row" into a macro if #N/A appears in a colu
I have several large workbooks in Excel with up to 28 sheets. I use a
VLOOKUP to enter pricing in the sheets, some 10,000. I have 50 offices with different product availability factors. If the product is unavailable a #N/A appears. I then go in and hide the row or rows where #N/A appears in the pricing column. There could be up to 150 rows that need to be manually hidden per sheet. Can this search and hide function be accomplished by building a macro which would search the entire workbook or even a single sheet to hide the rows which reflect the #N/A in a specific column |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format a cell such that "#NAME?" reads/appears "N/A"? | Excel Discussion (Misc queries) | |||
| Changing the incrementation when "puliing" cell values down a colu | Excel Worksheet Functions | |||
| Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
| How can I change "." to "," so e.g. 1.000 = 1,000 in the same colu | Excel Discussion (Misc queries) | |||
| How do you hide macro names from showing in "Tools"? | Excel Programming | |||
Threaded Mode
