Borders and sorting

Hi

I have a list which is to be added to and sorted regulary (already got the macro for sorting). Is there anyway I can get Excel to auto expand the border when a new item is added to the list? I have attached a picture so you can see the list

Thanks in advacnce

Rich

Excel.jpg

Hi,

Use dynamik range to change the border and shading range.

Hi

Thanks for your reply, but Im not sure how to do that.

Rich

Do you mean like this?

Please Login or Register  to view this content.

Just like that

Thank you

Rich