Search results 65

Sorted from new to old.

ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

2021Apr16

Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

2020Dec21

JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

2020Jul30

Switch Virtual Desktops

Ready to use exe application that helps you switching the desktop in Windows 10 ...

2020Mar6

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

1 2 3 4 5