Search results 420

Sorted from new to old.

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

Nov13

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

Nov10

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

Nov10

Showing 4k (and more) images in BS5 modal

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

Nov7

SSL/TLS certificate add/update

Always found myself struggling when applying security to websites for the past ...

Nov7

GetPapa + GetSon with variances

Gets the parent folder full name from a path Also Gets the son of a full path. ...

Oct26

Walking Columns (Scrollable Columns-Chart)

Allow users to scroll through columns in column-chart. Used chart.js, this is ...

Sep30

Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

Sep29

ANmaFiles2List

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

Sep21

StartApp-IfNotStarted

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

Aug3

FindZipFile_WShell

Finds the first zip in a folder matching wild cards mask using WScript.Shell ...

Aug2

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

Jul28

DownloadFile_Safe

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

Jul27

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

Jul26

Center Userform

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

Jul23

ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

Jul11

1 2 ...26 27