The sub is called by clicking on a column header (that is only visible when .View = lvwReport). Does the sub fire for you when you click a column header? I avoid calling events directly, but often have events call my own subs to share code.
If you need to manually call the sub (e.g. not only triggered by column header click), why not have the lvContact_ColumnClick sub code call another sub that that you can call manually (passing a column name)?
If that doesn't help, to be clear, the question you are asking is akin to Q: 'Why can't I call a button click event'? A: Why not just click the button? You'll have to explain better why you need to do this (and show us what else you have tried, after digesting the above information).
I got all the answers wrong on the GLAT, apparently even #9 (where I put a period in the middle of the box and labeled it 'singularity ripe for rapid inflation').
Thanks a lot, Cerian, this works perfectly for me.
To answer your question, I want the listview to open already sorted on a given column.
That column depends on where the listview is called from (so I can't use the Sorted property of the listview because I don't know which column upfront). For instance, I may want the listview to open sorted on the City one time, but sorted on the Annual_Sales another time.
Note that the user can then sort to his heart content later by clicking on the headers, but the listview is already sorted on the relevant criteria when it opens.
In any case, thanks a lot!
I would have written you a shorter letter, but I did not have the time.