ActiveWindow.ScrollColumn Sort

  • Thread starter Thread starter hotherps
  • Start date Start date
H

hotherps

Is there a way I can identify a range to be sorted without using th
scrollcolumn function.

I'm referring to the result of recording a macro selecting a range b
dragging you mouse.

My range = ("G11:CX298")

Thank
 
set rng = Worksheets("Sheet5").Range("G11:CX298")
rng.Sort Key1:=rng(1,6) ' sort on column L as an example

The sheet doesn't even need to be visible.
 
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

If statement in VBA 4
Deactivate macros but reactivate again once another macro is run 2
Excel Macro delete certail column's 1
Macro Error in Command Button 4
Data samples 3
Using a macro to delete cells from any row 4
macro to copy rows that contain a cell with a certain number 2
run macro on all closed workbooks in folder and subfolders 3

Back
Top