Column Sort

  • Thread starter Thread starter Shaz
  • Start date Start date
S

Shaz

Hello
I have a table of data.
I would like to sort a column using a macro however the column is
determined by the cell selected. Is this possible.

Shazz
 
Shazz

If the table is contiguous from cell A1 the code below will work

Sub SortBySelected()
Range("A1").CurrentRegion.Sort Key1:=Range(ActiveCell.Address), _
Order1:=xlAscending, Header:=xlGuess
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
You must log in or register to reply here.

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

MACRO RUN random percentage and copy of column values 1
Excel macro to aid visual clarity? 7
Using a drop-down box to sort data based on seperate columns 2
Moving a bunch of data 1
Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1
Filter out rows based on the value of a cell 4
Sort cells and "Place in this document"-hyperlinks 1
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top