Search results 117

Sorted from new to old.

Range().top below hidden rows

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

Jan13

Create Tree from 3 columns (Sheet2Tree)

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

2025Aug7

Site as app (PWA)

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

2025Jun19

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

2025May25

Str2Clean

Cleans string. Just another function to clean string from unwanted characters

2025May22

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

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

2025May2

ANmaUploadFTP_Script + ANmaUploadFTP_1File

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

2025Apr27

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

2025Apr12

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

2025Apr11

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

2025Apr10

String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

2025Apr10

String_S

Generate repeated text, like String() the function but with ability to repeat ...

2025Apr10

1 2 ...7 8