I added a 2nd module and placed code provided inside. I run it. A1 on sheet2 is the only cells on sheet2 that has double line borders.
Additional info about sheet2:
-Column A does not contain anything
-I have Merge & Center cells on sheet2
-I have Merged cells that span multiple columns and rows and that are wrapped
-all data shown on sheet2 is found in columns B through I
-J is the last column. It is blank and is used only for presentation purposes
-the left side of the border will always the left side of column A.
-The right side of the border will always be the right side of column J
-The top side of the border will always be the top part of row 1
-The bottom side of the border is the problem. It will always be moving and is dependent on what is entered in Sheet1. If the data goes past the 1st page when printed, I need the border to be around page 1 and page 2 - from top to bottom. (I hope this makes sense)
Some more info:
The code that I have in module1 is this: (Note that "_CADD3" is D7 on sheet1, "_CREFUND" is D15 on sheet1, "_COWED" is D17 on sheet1. I hope this helps.)
Thank you.
Bookmarks