Search results 272

Card image cap
HasDups

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

Card image cap
Copy formulas

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

Card image cap
CountArrayCol

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

Card image cap
HTMLDecode + HTMLEncode

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

Card image cap
FilesKill

Delete Multiple Files (with WildCards) To delete multiple files from a ...

Card image cap
CopyRowHeight

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

Card image cap
DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

Card image cap
LastInsertedID_SQL

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

Card image cap
ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output.

Card image cap
MatchLastIf

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

Card image cap
IsThere_Remote

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

Card image cap
Classic ASP vs VBA

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...