Hi all,
I'm having an issue with the borders generated by a simple macro that takes a spreadsheet with alternating shaded sets of rows, and creates a border everytime the shading colour changes. The core functionality of the macro is working fine, but it does not shade the bottom of cells in the 1st and last column of the bottom row on each page, or the bottom of the cells in the 1st and last column of the repeating header, when the document is converted to a PDF (this can be seen in Page Layout view after the macro is run)
I've attached a copy of a spreadsheet prior to running the macro (ie. shaded cells without the borders added yet), as well as the macro itself (code is below, it's also embedded in the file as "ShadingtoBorders"). If you run the macro on this spreadsheet, you'll see the problem appear.
I imagine this must be a simple fix, but it's beyond my talents. Thanks for any help you can provide.
Please Login or Register to view this content.
Bookmarks