How select active rows from A to D columns?
This works great.
Thanks
LD
--
Lorenzo DÃ*az
Cad Technician
"Barb Reinhardt" wrote:
Have you tried something like
Range("A1").CurrentRegion.Select
--
HTH,
Barb Reinhardt
If this post was helpful to you, please click YES below.
"ldiaz" wrote:
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.
--
Lorenzo DÃ*az
Cad Technician
|