Hi All,

Can I set Range A1:H2 with Formatting:
interior color =Black, font =White?
....
But if Usedrange.column H then Set Formatting
on Range:A1:Usedrange.column2

if usedrange.column<H then keep range A1:H2

Brgds Sige