I have two worksheets Work and Summary.

My issue is how to format the borders of those 2 sheets as per their ranges because the used ranged differs and are dynamic .

Sheet work column A to L

Sheet summary column A TO F

both sheets rows are dynamic

Used code below format only active sheet


Please Login or Register  to view this content.

the format code below format both worksheets to columns A to L as sheet summary are from column A TO F 

Please Login or Register  to view this content.