whats the VBA version of data>list>create list?

[buckwheat4948]

How do you do in VBA when you click Data>List>Create List>select the range so that the sort lists appear for each column in the range?

thanks

 

[Dazzawm]

Can you try recording it?

 

[buckwheat4948]

The range will keep changing and id like to automate it on sheet loadup.

 

[buckwheat4948]

Oh, i see where your going, lol. Ya, i just recorded it and got the code i was looking for.

Many Thanks....where's my head at sometimes...