ANmarAmdeen

  2. Programmers
  3. ANmarAmdeen
Card image
UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27
Card image
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13
Card image
Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6
Card image
FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

2020Apr20
Card image
Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14
Card image
DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3
Card image
DelFiles

A very simple to delete a directory and the entire files and folders in its ...

2020Apr1
Card image
IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1
Card image
NextID_Reset

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

2020Mar31
Card image
DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24
Card image
NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21
Card image
Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21
Card image
IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

2020Mar21
Card image
DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20
Card image
Captcha34

jQuery and bootstrap-based captcha, Restricted Content + Input Validator. ...

2020Mar17
Card image
Window off-screen

Window not shown while taskbar says it is on. Restore window position in ...

2020Mar17
12...29...7273