Search results 649

Sorted from new to old.

Recalculate cells with UDF

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

Fri 7PM

ANmArray_1stMatch_orPartial

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

Fri 8AM

MatchIfUp_DateTime

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

Aug4

ANmaTable_FieldValue_Concat

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

Jul26

ANmExcelTableAddress

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

Jul24

ANmExcel_Replace

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

Jul10

DuplicatedList

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

Jun21

CutString_Area

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

Jun1

File1st_Attributes_In

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

May31

ANmaTableAddress

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

Apr26

DateOffset_FromMMDD

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

Apr9

ANmaFormatLastRow

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

Mar26

FormatNumbers_InsideText

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

Mar9

ANmaDailyFolder

Creates folder daily in certain folder using certain mask (daily or any other ...

Feb11

ANStrColor2RGBA_Para

Returns Red, Green, Blue and Transparency from text representing color Like ...

2025Dec20

Variable_PerLocation_FromFullLine

Extract set from ANstring, like 2nd set of variable list using specific ...

2025Oct16

1 2 ...40 41