Quickly adds value to certain column in Excel sheet As usual, you can define ...
List all columns in all tables for all schemas in oracle db workbench
How to copy formulas in VBA code. Learned that the hard way, just like most of ...
Returns the count of array fields, given the dimension, using UBound ...
Convert items found in a column matching certain material into list in 1 cell ...
Finds last occurrence of a match in a column Finds the row of last time an ...
Unmerges all merged cells and duplicate cell contents into them. In another ...
Cards in Bootstrap 3, nice and smooth
Insert special characters inside Cell, using ChrW
Applies format into a cell (or range) from another cell. Can apply from any ...
Sort range or area by 5 columns, range can be any number of columns, but the ...
Sort range or area by 3 columns, range can be any number of columns, but the ...
Sorts a range or area by 1 column given its cell address, with options to ...
Sorts a column in Excel, easily, with options
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
Reads setting saved in columns J:R Just like SettingRead, but when we have ...
50 chars max.
