Code to print columns with active rows not working

**debbiesh** · 07-01-2009, 11:14 AM

Hello again! I have a code that will print all active rows on a spreadsheet, however I'm looking for something that will print certain columns when selected. Example:

Columns A - N contain data for seven departments.
I want to print columns B - D and then column F for one department; B - D with column G for another, etc. In other words, columns B - D will always be included with each department's column when it's printed.

Is there a way a button could be placed over each department's column (say, columns G thru M) that will allow that to happen...and keep my macro to print only active rows? If so, please point me in the right direction; my searches have produced dead ends. Thanks!!

**debbiesh** · 07-08-2009, 11:49 AM

Attached is a sample of what I have so far. A macro within each PRINT button is supposed to sort the column to contain "Non-Blank" rows and then print it. Three problems:

1) I must not have the right code to sort within each column because, well, it doesn't.
2) The code only wants to print down to the cell in row 8 rather than to the last active cell.
3) Once it's printed, the code doesn't unhide the rows.

Please help?

**debbiesh** · 07-09-2009, 01:33 PM

Here's the code I have for each column. This is for column H, Routing --

Please Login or Register  to view this content.

**debbiesh** · 07-10-2009, 09:08 AM

I figured out what was wrong with my code. So this works to where I can now click the button and the correct columns will do their thing -- autofilter to show non-blank cells, show print preview, then show all again.

Please Login or Register  to view this content.

The only thing I can't do now is print down to the last active cell. I must've lost that code while messing with the rest of it.

**shg** · 07-10-2009, 10:00 AM

Reset the print area to the whole sheet, Debbie.

**debbiesh** · 07-10-2009, 10:26 AM

Thanks for replying shg!

I don't know what happened but the code above now wants to include Columns A - C in the print preview, rather than B - C.

Also, it wants to print rows 4, 5, 7, and 10 no matter what active cells are in the column to be printed. *sigh*

Would it have to do with resetting the print for the whole sheet?

**shg** · 07-10-2009, 10:28 AM

Rewind a bit and explain what you want.

**debbiesh** · 07-10-2009, 11:07 AM

You're right, it does sound a bit confusing. Lemme try again.

I created six PRINT buttons, one for each column -- H, I, J, K, L, and M. I want the user to be able to click the button over one of those columns to print that particular column WITH columns B and C. I also want to only print the non-blank cells within that column.

So I'm trying to create a code that will autofilter a column to include only non-blank cells, and then print columns B, C, and that chosen column, down to the last active cell.

Make sense? Attached is another sample. I appreciate your help with this. I'm trying to make our production manager's job a little easier. :-)

**shg** · 07-11-2009, 05:14 PM

Debbie, try this:

Please Login or Register  to view this content.

Code to print columns with active rows not working

LinkBack

Thread Tools

Rate This Thread

Display

Code to print columns with active rows not working

Re: Code to print columns with active rows not working

Re: Code to print columns with active rows not working

Re: Code to print columns with active rows not working

Re: Code to print columns with active rows not working

Re: Code to print columns with active rows not working

Re: Code to print columns with active rows not working

Re: Code to print columns with active rows not working

Re: Code to print columns with active rows not working

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions