Search results 175

Sorted from new to old.

Bootstrap 4 progress bars variables

Enhanced way to use progress bars in Bootstrap 4 Using below variable ...

2020Feb1

FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

Random GUID

Generate a random GUID using oracle db workbench Also add timestamp to ensure ...

2019Dec22

GeneratePostID

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

2019Dec19

draggable grid

Nice gallery (or grid) that can be dragged to browse through From

2019Oct24

ASCII_Read + ASCII_Save

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

2019Oct22

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

jExcel

jQuery plugin to embed a spreadsheet, compatible with Excel, in your browser. ...

2019Oct3

Tabulator

A nice, advanced powerful table control in js From

2019Sep18

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

CopyRowHeight

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

2019Aug1

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

LastInsertedID_SQL

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

2019Jul18

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

MatchLastIf

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

2019Jun12

1 2 ...8 ...10 11