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