Search results 420

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

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

Img not found - Temp pic

Showing image not found if img src image is missing

2022May27

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

New VBS file

Add vbs to new menu in Windows Explorer. Fast way to create VBS files using reg ...

2022May3

BooleanCount

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

2022Apr22

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

Tabindex in multipage

Tabindex and forcing focus to show in textbox if we have multipage control. ...

2021Dec6

CleanArray

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

2021Sep22

1 2 ...9 ...26 27