Random codes

Codes Required

SheetDelete_ANmar

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

2018Aug9

ANmarAmdeen

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

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

ANmarAmdeen

Similar codes

SheetDelete_ANmar

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

2018Aug9

ANmarAmdeen

WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

2018Aug9

ANmarAmdeen

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

ANmarAmdeen

WorkbookSave_ANmar

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

Aug9

ANmarAmdeen

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

ANmarAmdeen

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Dec22

ANmarAmdeen

FindFile

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

2018Jul11

ANmarAmdeen

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23

ANmarAmdeen

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

Jul9

ANmarAmdeen

Recently by developer

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table.

Thu 3PM

ANmarAmdeen

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

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

Thin HTML5 Coming soon Template

Simple, elegant, thin template for Under Contruction site. Found it in my ...

Aug19

ANmarAmdeen

Star rating

Another Bootstrap rating system using Font-Awesome

2019Jun24

ANmarAmdeen

WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

2018Jun28

ANmarAmdeen

Replace Single Quotes

This script will replace single quotes so the data is SQL-safe

2018Apr16

JeffSmith