Search results 60

Sorted from new to old.

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

Excel user name

Get application user name or change it Originally from

2023Jun14

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

1 2 3 4