VBA Speed Sort ?

[Pinaceous]

Hi All,

I could of course record a macro but I have the need for speed.

How can I speed up my sorting job via written code versus a scripted code?

I'm using Excel 2013 & I want to quicken my sort criteria:
-expanded selection Columns C:2 to Column V:573
-not in deleting duplicates
-by Column G from smallest to highest

Many thanks in advance.

R/
Pin

 

[Arithos]

Hi All,

I could of course record a macro but I have the need for speed.

How can I speed up my sorting job via written code versus a scripted code?

I'm using Excel 2013 & I want to quicken my sort criteria:
-expanded selection Columns C:2 to Column V:573
-not in deleting duplicates
-by Column G from smallest to highest

Many thanks in advance.

R/
Pin

It should not be that slow tho, should it? That is usually not the part im worried about going to "slow".

Do you however need the range C2:V573 beeing dynamic? or will it always be this selection?

 

[Pinaceous]

Hi Sturla,

It will always be this selection. I just would like to see if there was a written VBA to accomplish this task.

Can you provide a code for this?

Thanks,
Pin

 

[shg]

Range("C2:V753").Sort Key1:=Range("G2")

 

[Pinaceous]

Wow shg,

I'm going to try this out ASAP! Thanks, I'm under the assumption that this will sort from 'smallest to largest'.

Many Thanks,
Pin

 

[shg]

You're welcome.

 

[Pinaceous]

Hey 'shg',

I know its been awhile, but do you also know how to also sort by 'A' to 'Z'?

If 'Range("C2:V753").Sort Key1:=Range("G2")' sorts by 'smallest' to 'largest'?

Many thanks,

Pin