0

I want to sort a table that already has headers with vba but it needs to exclude the first row as this has formula in it that is needed.

Is there a way to do this? Sort Table

Robert Hall
  • 191
  • 3
  • 11
  • Simply delete the first line underneath the header. Then sort by the relevant column(s) – Malte Susen Jul 13 '20 at 09:49
  • 1
    Please add the code you're using and we can help adjust it for you so it starts from the second row. – Super Symmetry Jul 13 '20 at 10:24
  • Yes; use the `Range.Sort` method. See the First Answer by Dmitry Pavliv to this [SO Question](https://stackoverflow.com/questions/21451458/vba-excel-sort-range-by-specific-column) – GMalc Jul 13 '20 at 14:48
  • @GMalc Ah ok, i will have a look at it, thanks. For the moment, i found that if i hide the row, it excludes it from the sort – Robert Hall Jul 14 '20 at 06:33

0 Answers0