Search results 358

Sorted from new to old.

Protecting VBA code

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

2022Jul6

Img not found - Temp pic

Showing image not found if img src image is missing

2022May27

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

CreateUniqueList

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

2022Apr26

ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

2022Apr21

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

Range_SaveAsImage

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

2022Feb16

GetGroupMembers

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

2022Feb1

OpenAnyFile

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

2022Jan28

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

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

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

1 2 ...7 ...22 23