If I have some rows and a row - say row 10 is higlighted in bold and I delete
row 4 like:
Range("4:4").Delete Shift:=xlUp

row 10 is still in bold but the data in row 9 should be bolded

Can I delete and shift up and force the format to shift up too?

If so how?

Thanks
Mike