Random codes

Codes Required

CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

Feb27

ANmarAmdeen

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

Feb25

ANmarAmdeen

CutString11

Cuts long string from certain character to certain character with option to ...

Feb24

ANmarAmdeen

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

Jan24

ANmarAmdeen

CutString9

Cuts from CutFrom starting from any of items found from ...

Jan7

ANmarAmdeen

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Jan1

ANmarAmdeen

CutString8

Cuts a string from certain character to certain character with option of either ...

2021May29

ANmarAmdeen

VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

ANmarAmdeen

CutString_Words_Left + CutString_Words_Mid

Cuts the left or Middle part of string without breaking words Can specify ...

2018Aug8

ANmarAmdeen

CutString1

Cuts a string from a string starting from a specific character index and until ...

2018Jul11

ANmarAmdeen

CutString3_Search

Using same code in CutString3, this will search for matching items. Searches ...

2018May29

ANmarAmdeen

CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

2018May29

ANmarAmdeen

CutString3

Cuts string from a larger one based on a specific separator.

2018May29

ANmarAmdeen

CutString3

Cuts a string from a larger one using separators.
Ex, CutString3("Will ...

2018May29

ANmarAmdeen

CutString3

Cuts string from a larger one based on a specific separator.

2018May29

ANmarAmdeen

Similar codes

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

Feb25

ANmarAmdeen

ANmaHTMLImgDownload

Downloads image from src of < img html tag after searching for list of ...

Aug2

ANmarAmdeen

HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

Feb28

ANmarAmdeen

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

Nov22

ANmarAmdeen

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

Oct24

ANmarAmdeen

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

Dec16

ANmarAmdeen

HTMLTagID_Previous

Return id for any html tag that was found above certain location of html page. ...

Feb2

ANmarAmdeen

Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

ANmarAmdeen

CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2

ANmarAmdeen

Recently by developer

MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

ANmarAmdeen

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

ANmarAmdeen

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

ANmarAmdeen

Logging use of executable in Windows

Log the use of .exe, .lnk, .pif, .bat, and .com files on your computer. All it ...

2021Jun13

ANmarAmdeen

Win10 User Folders

I hate it when Microsoft takes back some controls it already gave to users, one ...

2018Jul9

ANmarAmdeen

Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

2018Jun30

ANmarAmdeen