In my worksheet, I would always like to print Columns A-F and only the
individual columns in G-R that have at least one value (formatted as
Currency). If a given column between G and R has just the text heading in
rows 1 or 2 OR is blank (though preformatted for Currency), then I want to
suppress printing that particular column.

- I don't want to have to select the columns but would rather use VBA to
check whether Currency values exist in a column ornamed range

- I want whichever columns that meet the criterion to print as one
continuous range

Can anyone help?

Thanks, cspowell100