Search results 66

Sorted from new to old.

Calculation_StaleValues

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

2025Jun30

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

2025Jun1

BoldCodeColor

Bold the first letter and color it based on Bootstrap color theme, info, ...

2025May26

1st cell of sheet range

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

2025May12

ANmaUploadFTP_Script + ANmaUploadFTP_1File

Uploads 1 file to FTP. It will create temp script to login to FTP and uploads ...

2025Apr27

Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

2025Feb2

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

JSon functions to add, read and delete entry

3 Json functions to read full node by an image, add full node to file or delete ...

2024Oct29

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

FindZipFile_WShell

Finds the first zip in a folder matching wild cards mask using WScript.Shell ...

2024Aug2

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

1 2 3 4 5