Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Only print rows with text in col B
I have a summary page that I update each day. I want to add code to my macro
that will only print the rows from Col A to Col F if there is text in col B. I'm using this code but it doesn't seem to work, do you have any suggestions, thank you. ActiveSheet.PageSetUp.PrintArea = _ ' "$A$1:$F$" & Cells(Rows.Count, "B").End(xlUp).Row |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Only print rows with text in col B
This is one way:
Columns("D").Select Selection.Autofilter field:=1, Criteria1:="""" -- Best wishes, Jim "SITCFanTN" wrote: I have a summary page that I update each day. I want to add code to my macro that will only print the rows from Col A to Col F if there is text in col B. I'm using this code but it doesn't seem to work, do you have any suggestions, thank you. ActiveSheet.PageSetUp.PrintArea = _ ' "$A$1:$F$" & Cells(Rows.Count, "B").End(xlUp).Row |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Print # command print not all rows from excel sheet to file | Excel Programming | |||
Only print rows with text | Excel Discussion (Misc queries) | |||
Macro to hide rows with a certain cell empty then set print area and print | Excel Programming | |||
Print few rows with many colums so that rows wrap on printed pages | Excel Discussion (Misc queries) | |||
Will not print exactly as print prviw, skps text, prints on eithr | Excel Discussion (Misc queries) |