How do I use "hide a row function when #N/A appears" in a macro?

D

Dick

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 me 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?
 
S

Steve Schapel

Dick,

The focus of this newsgroup is macros in Access, the database programme.
You will have a better chance of good help with this in an
Exel-related newsgroup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
How do I build "hide a row" into a macro if #N/A appears in a colu 2
Adding a big matrix in Word 2013 5
Dealing with a Pivot Table (when I don't want to) 0
Sum Function When Formula Produces #N/A 2
hide products without pricing 6
Hide columns based on row values 2
hide rows in workbook 1

Top