Codes Required

Card image cap
FindSheet

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

2018Jun7

Similar codes

Card image cap
SheetAdd_ANmar

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

2019Apr1

Card image cap
DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

Card image cap
DeleteAllShapes

Delete all shapes in a sheet

2018Jun11

Card image cap
SheetName

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

2018Aug23

Card image cap
List_of_Names + DeleteNames

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

Jul9

Card image cap
WorkbookClose_ANmar

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

2018Aug9

Card image cap
RmDir

Delete a folder, expects to be an empty folder, path must be already MapPathed

2018Sep5

Card image cap
Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

Card image cap
Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

Recently by developer

Card image cap
ANmaHTMLTables_Combine2

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

Thu 3PM

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

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

Apr30

Random Codes

Card image cap
Send page to print

JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...

Aug11

Card image cap
List_of_Names + DeleteNames

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

Jul9

Card image cap
Preloader GIFs

A set of 83 animated GIFs that can be used as pre-loaders, or loading. You ...

2019Apr26

Card image cap
UserSign

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

2018Aug8