Last Page Only Range Area Macro. The starting point must be know. Find last row using find function let s see the code first.
When your starting point is not fixed it will be useless. Perhaps something like the following. You can only get last non blank cell in a known row or column.
To set print area in excel vba we have to use pagesetup printarea property.
To set print area in excel spreadsheet first select highlight cells that we want to set as print area and then navigate to ribbon page layout print area set print area. Perhaps something like the following. For a single selection the areas property returns a collection that contains one object the original range. Which is very less likely to happen.
