Search results 174

Sorted from new to old.

MatchIfUp_DateTime

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

Tue 4AM

ANmaTable_FieldValue_Concat

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

Jul26

ANmaFormatLastRow

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

Mar26

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

Formulas_FromFile_ToRow

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

2025Oct11

Formulas_FromRow_toFile

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

2025Oct10

Icon as text - CmdCaption_ChrW

Creates an icon as text to use inside button or any frm20 controls. this will ...

2025Jul17

Site as app (PWA)

Instructions on how to convert a website into an app, called Progressive Web ...

2025Jun19

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

2025Jun14

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

2025Jun14

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

2025May27

HTML_CountTags

Counts how many certain tag found in an HTML block. like how many tr found in ...

2025May16

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

2025May7

ANmaUploadFTP_FilesFrom2Columns

Upload files in column each to folder in next column. Expects to have two ...

2025May4

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

2025May3

1 2 ...10 11