Similar codes

Card image cap
SplitTo2DArray

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

2018Jul9

Card image cap
merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

Card image cap
CalcArea

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

Card image cap
RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

Card image cap
CountArrayCol

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

2019Aug9

Card image cap
CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

Card image cap
ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

Card image cap
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

Card image cap
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

Recently by developer

Card image cap
ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Wed 9AM

Card image cap
DecimalPlaces

Returns how many decimal places the number have

Wed 9AM

Card image cap
Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

Tue 4AM

Card image cap
IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

Thu 4AM

Random Codes

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

Card image cap
CSS Analog clock

Pure CSS Analog clock, found it in my archive

2019Jan7

Card image cap
CSSFlowChart

Shows a chart with links, nice sitemap maybe, or just easy way to show ...

2018Aug14

Card image cap
List and delete files

Enables users to list and delete files

2018Apr23