sort data

[spinkung]

Hi all,

I am trying to sort some data in my sheet after a refresh button is clicked.

I have this so far....

Please Login or Register  to view this content.

the red bit is where i'm going wrong i know but i can't seem to figure it out.

any ideas?

Cheers,
spinkung

[VBA Noob]

Try

Please Login or Register  to view this content.

then

Please Login or Register  to view this content.

VBA Noob

[spinkung]

thanks for the reply.


my final solution was

Rows(i & ":" & ilastrow).Sort


spinkung