Search results 549

Sorted from new to old.
Card image
ListItemText_to_ListIndex

Finds the index of an item in listbox (or combobox) It searches for that item ...

Card image
DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Card image
ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

Card image
CSS2PDF

Creates pdf from a css/html document. Looking to test it on next project ...

Card image
ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

Card image
ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

Card image
ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

Card image
ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

Card image
MaxOfArray

Gets the maximum number from an array. Like

Card image
CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Card image
RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

Card image
Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Card image
QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

Card image
Code128.js

Pure JavaScript library for generating barcodes using HTML5 canvas.

Card image
HTMLRow_Cell

Returns column with ColumnID ... the full area between < td ...> and < /td> ...

Card image
Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...