Search results 441

Sorted from new to old.

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

ArrSort_3Arr

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

2022Jul24

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

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

1 2 ...10 ...27 28