Search results 573

  2. Search results
  3. function
Sorted from new to old.
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
Card image
fnGenerateRandomString

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

2019May5
Card image
eMailMe (CDO)

Single asp file (having function) to send an email It is used here to send an ...

2019May3
Card image
ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14
Card image
Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

2019Apr3
12...20...3536