Search results 21

  2. Search results
  3. formula
Card image cap
Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2
Card image cap
ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11
Card image cap
Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

2020Feb16
Card image cap
Copy formulas

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

2019Oct3
Card image cap
CopyFormat

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

2018Aug10
Card image cap
CalcArea

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

2018Jul24
Card image cap
HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

2018Jun30
Card image cap
FormulasFlatten

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

2018Jun30
Card image cap
RGB2Long

Converts Red, Green and Blue integers into RGB long value

2018Jun2