Search results 667

Sorted from new to old.
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 ...

Card image
ANmaDailyFolder

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

Card image
ANStrColor2RGBA_Para

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

Card image
Variable_PerLocation_FromFullLine

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

Card image
Formulas_FromFile_ToRow

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

Card image
Formulas_FromRow_toFile

Exports all formulas in a row of sheet into text file.

Card image
RangeTakePicture_Linked

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

Card image
ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

Card image
ShapeDelete

Safely remove certain shape from worksheet

Card image
Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

Card image
ANmaUploadFTP_ANstrFilesto1Folder

Upload all files found in ANStr list of files into 1 folder. Passing all ...

Card image
Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

Card image
QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

Card image
CutString_JsonKeyValue

Reads value from json string for certain key. Using RegEx Regular Expression. ...