Search results 60

Sorted from new to old.

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

2019Dec19

RandomGUID

Creates a random GUID number like ... 879AE395-E026-0A63-EFC1-152038C4400B ...

2019Dec18

ASCII_Read + ASCII_Save

Reads or Saves text into file, giving its full path. Same as

2019Oct22

MinOfArray

Gets the id of an item with minimum in an array of numbers, with option

2019Oct20

LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18

Bootstrap 4 cheat sheet

Bootstrap 4 cheat sheet, quick direct link as image

2019Apr9

SheetAdd_ANmar

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

2019Apr1

HttpToAnchors

Convert http found inside text into anchers < a >, aka URLlinker, aka ...

2019Mar30

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23

Bootstrap Modal variables

Bootstrap link to pass variables to modal content Used to build list of links ...

2018Aug10

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

2018Aug9

ExportSheets_to_1PDF

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

2018Aug8

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29

CustomExcelMenu - FaceIDs

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

2018Jul19

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

1 2 3 4