Search results 59

  2. Search results
  3. Kill functions
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
FilesKill

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

2019Aug7
Card image
ConvertImage_IrfanView

Converts an image from any image into any image using IrfanView command line ...

2019Jun26
Card image
fnGenerateRandomString

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

2019May5
Card image
User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

2019Feb1
Card image
MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1
Card image
Num2Ar

Convert numbers into Arabic words, like 230 to مائتان وثلاثون I have multiple ...

2019Jan9
Card image
Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1
Card image
SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23
Card image
UnBreakAr + BreakAr

Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...

2018Jul25
Card image
VB6Format

Trying to create VB6 "Format" function in Classic ASP, works now for date only, ...

2018Jul24
Card image
SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9
Card image
Capitalize

This function capitalizes first letter of each of the words in a sentence, ...

2018Jul3
Card image
XorC

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

2018Jul1
Card image
Distance_Calc_fromString

Calculate distance between two points (Latitude, Longitude) LatLon1 and ...

2018Jun27
1234