How to Insert the Cell Border only the actual printing page
Posted on 2014-07-27
I have an excel sheet named " Sheet 1" an have data in Column A to N . The data are Placed from Row 10 to any row depends on the quantity of data .
I like to know the VBA code to insert the border only to the page that are actually filled with data . so it mean that for instance i have only one row of data , so i will have only 1 page , that entire page ( column A to N ) should have the Border on each cell ( from A10 : N10 to down the end of same page ) if instead i have more data that will fill more than 1 page , i will have the border down to the last entire page containing data . Thanks