I need a way to delete all the columns & rows through the end of the worksheet. Lets say I want to keep 1000 rows and 200 columns and want to delete all the rest.
I will add more columns and rows as needed and style them. Is there short way or vba for this? where I can set the range of columns and rows? please.
I know about Find&Select method, but it is not exactly same, and it is slow and also it selects the empty cells among the used columns and rows. Thanks.
I will add more columns and rows as needed and style them. Is there short way or vba for this? where I can set the range of columns and rows? please.
I know about Find&Select method, but it is not exactly same, and it is slow and also it selects the empty cells among the used columns and rows. Thanks.
Last edited: