I'm trying to find the first Small number in a one dimensional array as shown below. I'm trying to use SortArray() to define that range. Is this not possible? If so, how can I sort an array. Thanks.
L = WorksheetFunction.Small(SortArray(1), SortArray(4), 1)
Last edited by Aussiebear; 04-16-2023 at 04:10 PM. Reason: Added code tags
this may give you an idea:
the result is 10, which is the 5th smallest number in the array.PHP Code:MsgBox Application.Small(Array(1, 10, 45, 5, 60, 7, 9), 5)
PLS DO NOT PM; OPEN A THREAD INSTEAD!!!
1) Posting Code
[CODE]PasteYourCodeHere[/CODE]
(or paste your code, select it, click # button)
2) Uploading File(s)
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) (multiple files can be selected while holding Ctrl key) / Upload Files / Done
Replace company specific / sensitive / confidential data. Include so many rows and sheets etc in the uploaded workbook to enable the helpers visualize the data and table structure. Helpers do not need the entire workbook.
3) Testing the Codes
always back up your files before testing the codes.
4) Marking the Thread as Solved
from Thread Tools (on the top right corner, above the first message)
Not at all sure what you're trying to do but you might get more joy using Application rather then WorksheetFunction, especially if you're using an array as the 2nd argument of the Small function:
2023-04-05_114234.jpg
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
Reply With Quote
