delete and shift up
 

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

delete and shift up
 

use only the instruction:
Range("4:4").Delet

--
antoka0
-----------------------------------------------------------------------
antoka05's Profile: http://www.excelforum.com/member.php...fo&userid=2902
View this thread: http://www.excelforum.com/showthread.php?threadid=48766

delete and shift up
 

Not here it doesn't.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike" wrote in message
...
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