Search results 195

Sorted from new to old.

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

2020Feb5

GeneratePostID

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

2019Dec19

IsThere1_Image

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

2019Dec7

Freeze table head

Freezing head (thead) of a table when scrolling. Needed this feature for a ...

2019Sep5

HTMLDecode + HTMLEncode

Decode and encode back a string using HTML Technically found online, but ...

2019Aug9

Rows 2 Cell

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

2019Jul30

ImageOpen_IfranView

Opens an image using Irfanview (i_view32.exe attached which also inscludes a ...

2019Jul8

Windows Clock

Restore Windows 10 clock to Windows 7 Analog clocks

2019Jun28

Tabs27

Simple JS Tabs A Pen created at CodePen.io. You can find this one at ...

2019Jun18

MatchLastIf

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

2019Jun12

IsThere_Remote

Checks if a file can be reached online or no Same as

2019Jun7

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

2019May20

fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

2019May5

SheetAdd_ANmar

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

2019Apr1

GetWordCount

Counts how many words found inside a string. Using space, tab or enter as ...

2019Mar31

HttpToAnchors

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

2019Mar30

1 2 ...8 ...12 13