Search results 206

Sorted from new to old.

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

GenerateThumbnail.php

Generates thumbnail of an image and saving it in certain folder. Edit php to ...

2020Dec24

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

2020Mar21

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

XorD

Encrypt or decrypt a string using a key Similar to XorC, except you get to ...

2020Jan10

Add2Column

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

2020Jan3

IsThere1_Image

Searches for an image and return the file extension of found, or returns null ...

2019Dec7

MinOfArray

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

2019Oct20

HasDups

Indicates if an array contains duplicate values. returns True if more than one ...

2019Oct5

CountArrayCol

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

2019Aug9

1 2 ...8 ...12 13