Similar codes

SplitTo2DArray

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

2018Jul9

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

ConcaUFO_RowsfromSheets

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

2020Nov11

FormulasFlatten

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

2018Jun30

CountArrayCol

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

2019Aug9

HyperlinkFunction

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

Aug24

merge2Arrays

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

2021Sep21

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

Sep1

CalcArea

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

2018Jul24