Search results 229

Sorted from new to old.

ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

Fri 4PM

ANmaUploadFTP_FilesFrom2Columns

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

May4

ANmaUploadFTP_FilesListto1Folder

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

May1

VBInstr_Rev_Any

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

Apr11

NumberBeforeString

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

Apr10

String_Fx

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

Apr10

String_S

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

Apr10

NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

Mar20

TemplateLine_10Xs

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

Mar16

VBInstr_SpaceFriends_BetweenHTMLTags

Searches for string inside string with multiple possibilities, returns ...

Mar13

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Mar12

ListBox_Read and ListBox_Save

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

Mar11

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

Toggle5Values

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

Feb2

TrimLines

Remove all line breaks from text from a text. Not like

Jan31

1 2 ...14 15