Sorting columns with macros

J

John Waupotic

I'm using the code below to sort the Sheet1 cells in range
of A10 to C30. I'll always want the range to start at
A10, but right and bottom boundaries of the range may
change. Is there a way where you can specify the range
from A10 to "the end" of the worksheet?

Worksheets("Sheet1").Range("A10:C30").Sort _
Key1:=Worksheets("Sheet1").Range("A10")

Thanks,
John
 

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

Top