Search results 129

Sorted from new to old.

MatchLastIf

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

2019Jun12

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

2019Jun2

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

Boxed Shadow1

Pure CSS box shadow effect A Pen created at CodePen.io. You can find this one ...

2019Jan17

Navbar colors

Bootstrap set of colored Navbars made with

2019Jan16

RunRemote

Runs a macro from another workbook without parameters (WB Workbook has to be ...

2019Jan9

Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

2018Aug12

ApplyValidation_DropDown

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

2018Aug10

UserSign

Returns someones astrology sign using their birthday in m/dd/yyyy or m/dd/yy ...

2018Aug8

ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

2018Aug8

CustomExcelMenu - FaceIDs

How to create custom Excel menu, this one shows the IDs and icons of 20 icons, ...

2018Jul19

ExcelMenu_onfly

Creates Excel menu on the fly, list of menu items, command actions, and icons ...

2018Jul17

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

Sort1Col

Sorts a column in Excel, easily, with options Expects ... Row 1 is header, ...

2018Jul4

1 2 ...7 8 9