Sorting a Range

C

cmm

Hi,

I have a range of cells that starts from column A to Q over mutiple
rows. I tried a macro to sort the range but am constantly failing. I
recorded the manual action of highlighting the required rows, choosing
the sort columns (3) and then sorting (including header) but this is
failing. What I added in the macro is code to choose the last row (so
that when new rows are added the sort will include them dynamically.
Does anyone have a solution for this. I want to have a range with
headers and sort on 3 rows. Column A is sometimes emtpy, but I am only
sorting on EFG (which are always populated).

Thanks and regards

Cedric
 

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

Cannot sort a table containing text 5
Macro to sort variable data range fails 1
Sort Marco won't work in 2010 5
Sorting issue with frozen panes 11
Sorting a column based on required order 2
How to sort when I have multiple header rows (not included in sor. 1
Macro to sort selected area 4
Update defined name ranges after sort 3

Top