Search results 94

Sorted from new to old.
Card image
Recalculate cells with UDF

Force Excel to calculate Cells with UDFs inside VBA code UDF = ...

Card image
MatchIfUp_DateTime

Finds first cell in column that is a date/time from bottom to top (technically ...

Card image
Notes bad for speed

Excel macros performance Adding Notes to cells does affect speed in running ...

Card image
SetAllPictures_MoveAndSize

Set shapes to "Move and size with cells" All shapes inside a sheet (or all ...

Card image
ANmaTable_FieldValue_Concat

Concatenates fields in certain row each with its header and returns the full ...

Card image
ANmaFormatLastRow

Format last row found/added in Excel range to certain color. ColorText is the ...

Card image
Formulas_FromFile_ToRow

Imports formulas from file into list of cells defined in file itself into ...

Card image
RangeTakePicture_Linked

Converts a range in Excel sheet into picture. linked or unlinked. Important! ...

Card image
Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

Card image
UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

Card image
1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

Card image
MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

Card image
MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

Card image
ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

Card image
ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Card image
ANmaRemoveBlanks_1Col

Remove blank cells from 1 column