Search results 580

Sorted from new to old.

DownloadFile_Safe

Downloading file directly to machine without refreshing or going to another ...

Jul27

Unblock blocked macros.

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

Jul27

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Jul24

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

Jul23

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

Jul13

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

Jul7

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

CopyFiles Excel-Macro

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

Mar12

Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

Mar5

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Mar3

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Mar2

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

Feb23

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

Feb18

1 2 ...36 37