Sort data with a varying range

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I need help with a code to do the following: needs to keep rows together (all
text-1 together as shown below) but sort in relation to column of my choice
(A,B,C, etc). There maybe columns added that will need to be included so it
has to read starting from A6 over right to last cell with data in row 6.
There may also be rows added so it has to read from A6 down to the FIRST
blank cell not the last (as shown below in A9).

A B C
6 text-1 text-1 text-1
7 text-2 text-2 text-2
8 text-3 text-3 text-3
9
10 Total

Thank You in advance
 
why not just use a defined name range something like
sortrng
=offset($a$1,0,0,counta($a:$a),counta($1:$1))
 
To do this
insert>name>define>name it sortrange>type in(or copy what I posted) into the
refers to box>OK>use that for your sorting

range("sortrange").sort...............
 

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

Back
Top