I’m looking for a way (I assume VBA code) to only print rows where column B is displaying data (i.e., B<>””). All cells in column B have a formula in them but depending on data input, many will appear blank; therefore, the number of applicable rows varies. That is, sometimes I may want to print B30:K35, other times it may be as large as B30:K777. The entire potential print range is B30:K1000.