Last Page Only Range Area Macro. The starting point must be know. This example resizes the selection on sheet1 to extend it by one row and one column.
Worksheets sheet1 activate numrows selection rows count numcolumns selection columns count selection resize numrows 1 numcolumns 1 select this example assumes that you have a table on sheet1 that has a header row. 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. What if you wanted it to be the current region.
Range areas property excel 05 10 2019.
Find last row using find function let s see the code first. For a single selection the areas property returns a collection that contains one object the original range. Find last row using find function let s see the code first. Cons of range end method.