Search results 46

Sorted from new to old.

CutString96_NumberBefore and After

Cuts the number found before our search word by going back certain number of ...

Nov24

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

Nov17

Showing 4k (and more) images in BS5 modal

Allow users to browse and scroll through tons of images to select one (tried on ...

Nov7

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

Nov1

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

Sep23

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

Aug2

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

Jul27

Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

Mar23

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Jan31

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Jan20

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

OutlookFolder_DuplicatesCount

Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...

2022Dec31

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

1 2 3