Search results 13

Card image cap
Cell_Add_or_Subtract

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

Card image cap
HyperlinkFunction

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

Card image cap
DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

Card image cap
Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

Card image cap
COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

Card image cap
NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

Card image cap
Highlight row of current month

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

Card image cap
ANmaCopy_Objects

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

Card image cap
Evaluate

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

Card image cap
Copy formulas

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

Card image cap
CalcArea

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

Card image cap
FormulasFlatten

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