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
CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Mon 1PM

Card image cap
Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

Sun 7AM

Card image cap
JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

Card image cap
CutString97

Cuts part from large string from certain character to certain character with ...

Jun5

Random Codes

Card image cap
PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Jan23

Card image cap
MinIF and MaxIF in Excel 2010

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

2019Feb1

Card image cap
OpenOffice Calc

OpenOffice programming with Visual Basic Some document I had for my reference.

2019Jan5

Card image cap
LoadingSquare

Loading animation in CSS only

2019Jan5