How select active rows from A to D columns?

L

ldiaz

I have a spread sheet like this, I want to make a macro to sort by Column A,
the problem is that the macro is written with an specific row:
Range("A1:D8").Select

How can I change the code to select active rows from column A to D?
and then apply the sort by column A, remember that rows may change from 8 to
20 or 1000.
A B C D
1 Part Desc Qty LOC
2 A15245 Etc 15 502A
3 B15245 Etc 15 503A
4 A15245 Etc 15 502A
5 C15245 Etc 15 501A
6 D15245 Etc 15 502B
7 A15245 Etc 15 502B
8 515245 Etc 15 502A

Thanks in advanced.
 

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