Print certain rows of certain columns based on variable

**Gaellus** · 03-13-2017, 05:32 AM

Good morning,

I would like to make a print macro which will print certain cell values of certain columns when the row has met the right condition. In this example "yes"
See attached.

So in this example I would like to print row 3,4, 7 and 9 but only the values from column A,B,C and G.

Thanks in advance!

**LeoTaxi** · 03-13-2017, 06:07 AM

Maybe

Sub test()
Range("A2").CurrentRegion.AutoFilter 9, Criteria1:="Yes"
Range("D:F").EntireColumn.Hidden = True
Range("H:I").EntireColumn.Hidden = True
Range("A2").CurrentRegion.PrintPreview
ActiveSheet.Columns.Hidden = False
Range("A2").CurrentRegion.AutoFilter
End Sub

Kind regards
Leo

**Gaellus** · 03-13-2017, 07:04 AM

Works like a charm. Thanks

**Gaellus** · 03-17-2017, 08:06 AM

NVM. not necessary anymore

Print certain rows of certain columns based on variable

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Print certain rows of certain columns based on variable

Re: Print certain rows of certain columns based on variable

Re: Print certain rows of certain columns based on variable

Re: Print certain rows of certain columns based on variable

Thread Information

Users Browsing this Thread

Similar Threads

sorting columns based on row criteria, with variable number of columns

[SOLVED] Dynamic summing of columns based on variable rows and dates

Print a variable range based on cell reference

Print Area:last row is variable depending on how many rows

Macro to print variable number of rows

Transpose Columns To Rows (with Variable Columns)

Variable Print Area Macro Based on Cell Value

Bookmarks

Bookmarks

Posting Permissions