Search results 244

Sorted from new to old.

Filename_Clean

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

2023Jan11

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

SmartMenus for WordPress

Cascading menu, on all devices. From ...

2022Jul11

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

A is for Alpha

Military way to communicate letters in audio, for me I learned not all required, ...

2021Dec6

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

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

1 2 ...5 ...15 16