Data sort dialogue

Hi all,

I am recently learning VBA and enjoying it quite alot.

I want to, once my macro has finished, to prompt the sort dialogue box to allow the user to sort out the data based on customized paramaters. These customized paramaters varies quite alot so it would need to be adjusted per data set.

So i was wondering what code would i need to incorporate to my existing macro to prompt the data sorting window?

Thanks!

Originally Posted by Andy Pope

Please Login or Register  to view this content.

Make sure the active cell is in the area of data to be sorted.
Or select the actual range of cells to be sorted

Thank you, worked perfectly!