Random codes

Codes Required

FindFile_Word

Finds a file within open documents of current instance

2018Aug9

ANmarAmdeen

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

ANmarAmdeen

Similar codes

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9

ANmarAmdeen

FindFile_Word

Finds a file within open documents of current instance

2018Aug9

ANmarAmdeen

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

ANmarAmdeen

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

2018Aug9

ANmarAmdeen

IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1

ANmarAmdeen

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

ANmarAmdeen

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

Aug9

ANmarAmdeen

Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

2019Apr3

ANmarAmdeen

Run macro

Runs a macro from another workbook (Workbook has to be open).

2019Jan9

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

Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

Aug1

ANmarAmdeen

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

ANmarAmdeen

UserSign

Returns someones astrology sign using their birthday in m/dd/yyyy or m/dd/yy ...

2018Aug8

ANmarAmdeen

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8

ANmarAmdeen