Reset used range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Let's say your data range is (a2:d200)..... when you do Ctrl+End, you are taken to d200(which is the end of the data range).... if you delete rows, your actual data range is different than it was before. How do you reset the data range to go to the actual range when you do Ctrl+end???
 
Back
Top