Search results 514

Sorted from new to old.
Card image
ANmaPairedStrings

Build pairs of lists of strings and returns both strings Takes the worksheet, ...

Card image
ANStrSearch2

Searches for an item in an ANStrList list by comparing the left part of items ...

Card image
ExactTop and ExactLeft

Finds the actual distance (Top) of a cell in pixels, and another function for ...

Card image
Recalculate cells with UDF

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

Card image
ANmArray_1stMatch_orPartial

Returns the 1st item found in array matching partially the search for value. ...

Card image
ListBox redraw bug (fm20)

Fix to the bug that when changing item in listbox that is not visible because ...

Card image
Notes bad for speed

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

Card image
ANmaTable_FieldValue_Concat

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

Card image
ANmExcel_Replace

Replace text in cell using Excel built-in Replace function. Ability to do ...

Card image
Win11 instant Startup apps

Force Win11 to start startup apps instantly without waiting for idle state. ...

Card image
CutString_Area

Returns full area found in ThePage between Between_Char1 and and_Char2 that ...

Card image
File1st_Attributes_In

Gets details of first file found in folder, based on requested order, byt name, ...

Card image
ANmaTableAddress

Returns the full name of table with its sheet name to be used in formulas or in ...

Card image
DateOffset_FromMMDD

Calculate the new MMDD from a date formated as MMDD after adding/subtracting ...

Card image
ANmaFormatLastRow

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

Card image
FormatNumbers_InsideText

Formats all numbers found inside text to certain format. Excluding numbers ...