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
ANmaPivotTable_Clear

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

Dec22

Card image cap
SheetDelete_ANmar

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

2018Aug9

Card image cap
SheetName

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

2018Aug23

Card image cap
Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

Card image cap
FindName

Finds a name in a workbook, returns true or false

2018Jun10

Card image cap
CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

Card image cap
List and delete files

Enables users to list and delete files

2018Apr23

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
CutString11

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

Feb24

Card image cap
SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

Nov12

Card image cap
DB connection driver

What is the Driver part in ConnectionString

Jun2

Card image cap
Programming Languages

A nice illustration on different types of languages (the most famous ones only) ...

2018Aug31