Search results 464

Sorted from new to old.

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

DynamicFill

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

2022Mar11

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

GetGroupMembers

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

2022Feb1

UISetup + UIRestore

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

2022Jan28

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

RowList_Matching

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

2021Dec27

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

A is for Alpha

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

2021Dec6

1 2 ...11 ...28 29