Search results 61

Sorted from new to old.

FormatNumbers_InsideText

Formats all numbers found inside text to certain format. Excluding numbers ...

Mar9

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

2025May12

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

2025Jan8

VBInstr_Any

Search for string inside another, with ability to have multiple strings to ...

2024Nov15

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

2024Sep21

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

2024Sep5

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

2024Sep3

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20

ANmaRead_1stFile

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

2024Aug11

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

2024Apr30

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

2024Mar12

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

2024Jan30

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

1 2 3 4