Search results 583

Sorted from new to old.

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

Aug7

StartApp-IfNotStarted

Checks if application is already running, returns 1 or 0 My first function

Aug3

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

Jul30

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

1 2 ...36 37