Search results 95

Sorted from new to old.

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

2019Aug1

ConvertImage_IrfanView

Converts an image from any image into any image using IrfanView command line ...

2019Jun26

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

This Year

A quick JS way to get the year of today, a method found it online, and wanted ...

2018Dec16

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

FixPath_Word

Fixes the path for a given folder, PC or Mac by adding separator only if ...

2018Aug9

LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

2018Jul7

Active BS4 breakpoint

Was looking for some way to show bootstrap 4 breakpoint, and got this

2018Jul6

Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

2018Jun30

CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26

ANBS controls

Set of functions to generate Bootstrap controls as strings. Controls available ...

2018Jun24

1 2 ...5 6