Search results 60

Sorted from new to old.

Convert_Dash_to_Zero

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

2023Mar14

FontAwesome icons in Office apps

Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...

2023Jan31

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

2022Feb1

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

File_SettingRead

Reads setting from config file Config file can be passed as argument ...

2020Sep23

DB_Connect_Install

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

2020Mar24

NameNum

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

2020Mar21

IntlIsAlphaCharacter

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

2020Mar21

1 2 3 4