Macro for conditional formatting bottom border

[graiggoriz]

Hello,

I wonder if it is possible to create a macro that would detect end page (jumping from page 1 to page 2 for instance) and add a bottom border at the last row of the page.

I have attached a sample where I highlight in green the end of the page and added manually the bottom border (I did it only for the first end pages).

I would really appreciate if you can help me with that?

Many Thanks,
Graig

[nathansav]

Please Login or Register  to view this content.

[watersev]

hi Graig, sort of that

Please Login or Register  to view this content.

[graiggoriz]

Hello watersev,

It kind of work but I need to have the bottom line for the columns B:F. do you think it is possible?

Thanks,
Graig

[watersev]

Please Login or Register  to view this content.

[graiggoriz]

I only miss the B column. Otherwise it works nicely! I tried to modify your macro but I got lost it doesn't work for me :-S can you please help me?

[watersev]

if to run the code in your posted file the line goes from B to H

[watersev]

do you mean this?

Please Login or Register  to view this content.