VBA to add a border to a report and sort a column

Hi,

I've been building a report in which millz has been instrumental in helping me deliver. Link

The final thing I would like to do is to add a border around the outside of the report and sort the 'charge' column (K) descending. I thought I would be able to obtain the code for this by using the macro wizard but this is returning a lot of code, most of which I imagine is unneccessary.

Please note that this report will be used regularly for various searches so I need the code to remove the old border and reapply it to the new data each time a search is run.

Thanks in advance,

Snook

Hi Snook,
try changing this line

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

and add these lines

Please Login or Register  to view this content.

Hi nilem,

That adds criss cross borders across all cells in the data range i'd prefer just an outside border. Is that possible?

Thanks

Snook

Please Login or Register  to view this content.