Similar codes

Card image cap
ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

Card image cap
O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

Jul10

Card image cap
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

Card image cap
AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

Card image cap
NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

Card image cap
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Card image cap
ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...

2019Jun28

Card image cap
MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

Card image cap
CopyFiles Excel-Macro

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

Mar12

Recently by developer

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

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

Apr30

Card image cap
MatchIf2Up

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

Apr29

Random Codes

Card image cap
Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14

Card image cap
ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

Jan9

Card image cap
eMailMe (CDO)

Single asp file (having function) to send an email It is used here to send an ...

2019May3

Card image cap
FindName

Finds a name in a workbook, returns true or false

2018Jun10