Identify a section of an Excel sheet and then sort it.
Posted on 2013-11-09
In my Excel data sheet, I already have chosen a row number as the start of a section of data rows, how can VBA determine the last row of that section (this is the row that has no data/blank in column A). So now, I have identified the start and stop row numbers.
Then if I have a column number (another integer) I would like the VBA to sort the section of rows in descending order. (at that point I will sum the first n entries to get a concentration value of some type(ie ;the top 10 items encompass 22% of the total value...')
This will help me learn how to identify variable sized data blocks and then sort/manipulate them.
In my sample file, the data starts on row 2 and I would sort on column 3, descending.