Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I am writing a Sub to process a CSV. This code will perform (amongst other bits) a SORT on the data. However, the sort procedure will vary with the data - such that the sort Range, Order & Key will vary. I was hoping it would be possible to supply the range,order & key TO the Sub, and then use the passed information within the SORT vba code to perform the function... but I can't find any information regarding declaring the Order operands etc... can this be done? I know that the Key can be specified by referencing a cell, but can I just use an expression directly? What is Order object / operand to be declared as etc? Any guidance greatly appreciated. KR Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add-ins query wizard operands (criteria tab) | Excel Discussion (Misc queries) | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
Weeks of Supply Function | Excel Worksheet Functions | |||
custom toolbar for operands | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |