Search results 20

Sorted from new to old.

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

2025Jul27

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

2025Mar16

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

2025Mar11

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

2025Jan8

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25

MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

2024Apr29

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

2024Apr8

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

2024Feb3

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

OST Outlook file location

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

2022May12

Bootstra/386

A bootstrap v2, v3 or v4 theme to make webpages look like they are from the ...

2021Jan6

404 page

A nice simple 404 page with a game From

2020Feb16

1 2