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???
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy and paste cells non-randomly form range 3
writing a sort macro 2
Offset/Index/Match ... or something? 3
How Do I Load a ComboBox From a Dynamic Range 1
Time with VBA code 8
Using Formulas to Return a Range 3
Is it possible have a message ( visual or Audio ) when the Curser is place in a cell? 4
Insert Row 2

Back
Top