kiekar
02-27-2007, 03:04 PM
Hello,
Is it possible to sort two columns programmatically using vba in an excel file. I haven't had much luck finding any good tutorials.
Presently I have an excel file which has 3 sheets. I wrote a funtion using the vb editor and added a module. This function extracts certain data from several columns from sheet one which has 21 columns. In order for the function to extract proper data, I need to sort two columns in ascending order.
How would I go about doing this? any help would be much appreciated.
Karl
Is it possible to sort two columns programmatically using vba in an excel file. I haven't had much luck finding any good tutorials.
Presently I have an excel file which has 3 sheets. I wrote a funtion using the vb editor and added a module. This function extracts certain data from several columns from sheet one which has 21 columns. In order for the function to extract proper data, I need to sort two columns in ascending order.
How would I go about doing this? any help would be much appreciated.
Karl