It appears you have not yet registered with DEVPPL. To register please click here... (it's fast, easy and free!)

Forum

Log In Sponsors
Board index Programming Visual Basic Forum

Help with user defined function

Moderator: dafunkymunky

Help with user defined function

Postby suds on Wed Nov 15, 2006 4:41 am

I was wondering if anyone you could help with a simple problem. I am not very used to VBA functions. I was wondering if you could help with a simple VBA routine that allows me to sort the data in a column in descending order. I have 3 columns with data and want to sort the column 1 in descending order with corresponding data in column 2 and 3 matching the correponding column 1 data.

I am able to record macros and do it, but I would need a function that actually creates a user defined function in the dropdown function list in the spreadhsheet. Putting the recorded macros in a function did not help. I guess its its very simple for wizs out here. I would need a user defined function for my problem to be solved.

Would appreciate your help.
suds
 
Posts: 0
Joined: Wed Nov 15, 2006 2:28 am

Who is online

Users browsing this forum: Yahoo [Bot] and 5 guests