Search results 642

  2. Search results
  3. function
Sorted from new to old.
Card image
ASCII_Read + ASCII_Save

Reads or Saves text into file, giving its full path. Same as

2019Oct22
Card image
ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...

2019Oct20
Card image
MinOfArray

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

2019Oct20
Card image
HasDups

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

2019Oct5
Card image
Copy formulas

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

2019Oct3
Card image
CountArrayCol

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

2019Aug9
Card image
HTMLDecode + HTMLEncode

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

2019Aug9
Card image
FilesKill

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

2019Aug7
Card image
CopyRowHeight

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

2019Aug1
Card image
DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22
Card image
LastInsertedID_SQL

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

2019Jul18
Card image
ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...

2019Jun28
Card image
MatchLastIf

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

2019Jun12
Card image
IsThere_Remote

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

2019Jun7
Card image
VBA vs ASP Classic

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

2019Jun2
Card image
HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

2019May31
12...24...4041