How to set print area with some cells blank

[Jeddo]

I need to set a variable print range in which some of the columns will have blank cells. The width of the print range is set; AZ6 to BC6, the length will vary depending on the data that varies. Columns AZ and BA will always have data in them, BB and BC may or may not have data in them.

I've used the following formula that will print to the end of the data, but can't figure out how to include BB and BC columns to the print range:

Range("AZ5", Range("BA8").End(xlDown)).PrintOut

Thanks for any help

 

[Fluff]

How about

Range("AZ5:BC" & Range("BA8").End(xlDown).Row).PrintOut

 

[Jeddo]

I've tried that before and I get an error message. I believe I need to tell it to go two columns over after it reaches the last row with data, but I'm not familiar enough with the syntax.