Search results 171

Sorted from new to old.

MatchIf8

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

May10

MatchIf8Up

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

May7

ANmaUploadFTP_FilesFrom2Columns

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

May4

MatchIf7Up

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

May3

MatchIf7

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

May2

ANmaUploadFTP_FilesListto1Folder

Creates script to upload list of files found in column. Will upload all files ...

May1

MatchIf4Up

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

Apr12

VBInstr_Rev_Any

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

Apr11

String_Fx

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

Apr10

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

Mar16

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

Mar11

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

Mar10

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

Feb26

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

Feb19

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

Jan12

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

Jan8

1 2 ...10 11