Search results 106

Sorted from new to old.

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

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. Needs ...

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

ScreenRes

Reads screen resolution, using IE this time, this one will get the active ...

2018Jun17

ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

2018Jun17

CellCommentRead + Save

Reads/Saves a comment into a cell CellCommentRead to Reads comment from a ...

2018Jun17

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

2018Jun16

1 2 ...6 7