Print specific rows/columns IF a cell meets criteria

**tiannaleft** · 10-15-2012, 12:24 PM

Hello,

I have spent the last 45 minutes going through different threads that came up in a search for printing marcos and my head is spinning so I thought I would just ask instead.

I would like to have a macro that will print columns A through I IF column B says REVCO. This would need to print to a network printer that is not the default printer on the computer so if that matters, the address of the printer is \\SMSKPPRT23\p1275_lab_c326a_1

I am trying to upload the file but it isnt working so I will keep trying but if there is a code in the meantime, that would be awesome.

**jayinthe813** · 10-15-2012, 01:09 PM

Need to know where in column "B" Revco Occurs, but this assumes it occurs in "B1", and your data extends down column "A":

Please Login or Register  to view this content.

Then, we will tie in the following to send the document to the printer:

Please Login or Register  to view this content.

So im assuming we need the network printer name

**g8r777** · 10-15-2012, 01:29 PM

After the area to print has been set, why not just bring up the Print dialog and let the user pick?

Please Login or Register  to view this content.

I like this approach since the other way hard codes a printer. If you ever want to print to a different printer you have to go in and modify the code.

**jayinthe813** · 10-15-2012, 01:42 PM

Yeah, but he sounded like he wanted to more automate the entire process completely, but you are correct, it is a big assumption and if that printer changes, or changes are needed, code will need to be modified...

**tiannaleft** · 10-15-2012, 01:48 PM

Thank you both so much. What I need is for the macro to look for REVCO in ANY of the cells in column B (not just B1) and then I only want it to print columns A-I in those rows that have REVCO.

**tiannaleft** · 10-15-2012, 01:48 PM

Oh and thanks for the printer code for brining up the dialog box - that is super helpful.

**tiannaleft** · 10-15-2012, 01:53 PM

I put in this code:

Please Login or Register  to view this content.

And it works, however it still prints rows that do not say REVCO in column B....Do I need to set a filter?

**jayinthe813** · 10-15-2012, 02:29 PM

you will need to do this:

Please Login or Register  to view this content.

what is the name of the printer and we can automate it or replace what i highlighted in bold with g8r777's solution:

Please Login or Register  to view this content.

**tiannaleft** · 10-15-2012, 02:54 PM

Thank you so much. When I ran the macro, it gave me a type mismatch error for this row:

Please Login or Register  to view this content.

Also, it wants to print each row on a separate page. Is it possible to print them all on one page? Also, is it possible to have row A print at the top? It is a header row....
Inventory Test 4.xlsm

FINALLY got the file attached!

**jayinthe813** · 10-16-2012, 08:51 AM

Try this:

Please Login or Register  to view this content.

Please note, in the example you provided, the first "REVCO" was entered in as " REVCO", you will need to make sure you data enter cells correctly in order for this to work, or you will need to introduce * as wildcard, OR if beginning spaces are a problem, you will need to go to Data tab > Text To Columns > Fixed Width and press finish