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
MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

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

Card image cap
MatchIf2Up

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

Apr29

Random Codes

Card image cap
Sidebar navbar

Bootstrap side navbar (sidebar) Can be pushed to left or right From

2019Aug8

Card image cap
Tabs22-BS3

Dark red tabs in bootstrap 3

2019Apr24

Card image cap
Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

2018Dec30

Card image cap
Capitalize

This function capitalizes first letter of each of the words in a sentence, ...

2018Jul3