Search results 653

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
ArrSort_6Arr

Sorting 6 arrays same order as 1 array.

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
MatchIfUp_DateTime

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

Card image
ANmaTable_FieldValue_Concat

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

Card image
ANmExcelTableAddress

Returns reference of a table in Excel workbook. This is because not all tables ...

Card image
ANmExcel_Replace

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

Card image
DuplicatedList

Returns list of duplicated items in a range as ... ' ...

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 ...