Workbook>Beforesave function to add cell borders

Hi all,

I have a spreadsheet that I'm working on and I'd like to include a beforesave macro to format the spreadsheet.

Basically I need a macro to select all rows with data in column 'a' and add a thick border to the top of the cells. Ideally the border would stop at column 'i' but that's not essential.

I've attached an example of what I'd like. I've included 2 sheets 1 called 'before' and 1 called 'after'. They show what I'm after.

Thank you so much for your help.

Andrew

Put this macro into the ThisWorkbook module:

Please Login or Register  to view this content.

Brilliant! Thank you so much for your help JBeaucaire - problem solved

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)

========
NOTE: Only use the QUOTE button when you want to quote out and discuss something specific. To simply reply or continue the conversation, just use the QUICK REPLY box below... the resulting thread will be much cleaner and easier to read.