1

I am trying to make a VBA code autosort data based on the data in the N column but I am stuck up on how to make it sort between two rows where the range may change. In other works I have two columns,

1) Ensign 88

2) Precision 560

The number of rows between them will allways be changeing (adding and deleting), but I dont want it to sort the rows outside those two title rows.

enter image description here

Community
  • 1
  • 1
David Van der Vieren
  • 265
  • 4
  • 11
  • 25
  • 1
    is it possible to update your question attaching a print screen of your Sheet with these above columns and sample data? – bonCodigo Dec 20 '12 at 16:09
  • 1
    maybe [this](http://stackoverflow.com/questions/11169445/error-finding-last-used-cell-in-vba) will help ... to help you find the last row for the column(s) you want to sort on. – Scott Holtzman Dec 20 '12 at 16:47
  • 1
    `Way 1:` Name your range and sort that named range? Whenever you add more rows, the named range will automatically adjust. `Way 2:` Use .FIND to find "Ensign 88" and "Precision 560" and then construct your range – Siddharth Rout Dec 20 '12 at 18:30

0 Answers0