Search results 81

Sorted from new to old.

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

iframe link to parrent

Link to the parent from inside an iFrame using JAVA

2020Feb3

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

Max + Min

Calculate maximum of array of numbers or Minimum of array of numbers Also, ...

2019Dec31

Parallax Flipping Cards

CSS animated flipping cards From

2019Oct23

1 2 3 ...5 6