Search results 60

Sorted from new to old.

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

2025Jun14

USB Format in Car stereo

What format used to let Car stereo read USB thumb drive? To listen to MP3 ...

2023Sep29

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

Excel user name

Get application user name or change it Originally from

2023Jun14

Autofit height iframe

iframe with animated gif to show while loading content, when iframe is fully ...

2023May25

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

2021Aug3

HTML5 tags cheatsheet

A simple graphic illustrates the new HTML5 tags and differences against old ones

2021Apr16

Functions.dll

Old DLL housing list of functions to be used and called by any application, ...

2020Jul18

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

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

1 2 3 4