erbhaskar95
New Member
- Joined
- Apr 30, 2021
- Messages
- 14
- Office Version
- 2016
- Platform
- Windows
Lets say I have my main excel workbook that contains 2800 rows (filled with data). I copied some information or range of rows from another workbook and pasted it in my main excel workbook. The pasted range was upto 1500 rows only. Now how can I delete the range from one cell below the last pasted cell row (i.e 1501 in this case) to 2800 rows? Sometimes it might be 1400 rows or 1700 rows depending on situations so my main objective is to delete the rows from one cell below the last pasted range upto the end (i.e row number 2800)