Sort without affecting formatting

[Kungfauxn00b]

Hi all,

Apologies if this has been asked elsewhere (I thought it would have been) but I can't find any information on it.

I have a table of information in an sheet that I want to run a macro on to, along side other things, sort in date order.

My problem is that it's taking the formatting with the sort. So instead of alternate line colours, I'm getting a block of colour.

I've recorded the macro for sort to see if there's anything to change but I don't really know what to look for.

Here's the sort code:

Please Login or Register  to view this content.

Hope this makes sense.

[shg]

Use conditional formatting for your line banding. See http://www.mrexcel.com/articles/gree...g-in-excel.php