Random codes

Similar codes

FindName

Finds a name in a workbook, returns true or false

2018Jun10

ANmarAmdeen

SheetAdd_ANmar

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

2019Apr1

ANmarAmdeen

ANmaPivotTable_Clear

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

Dec22

ANmarAmdeen

Excel sheet textbox

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

2020Feb22

ANmarAmdeen

FindFile

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

2018Jul11

ANmarAmdeen

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

ANmarAmdeen

SheetDelete_ANmar

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

2018Aug9

ANmarAmdeen

CellRead (SimpleLookup)

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

2018Jun25

ANmarAmdeen

CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

ANmarAmdeen

Recently by developer

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

ANmarAmdeen

Files_FoundHours

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

Tue 7AM

ANmarAmdeen

MatchIf2Up

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

Mon 9AM

ANmarAmdeen

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

ANmarAmdeen

Antispam - Hiding textbox

Anti spam email web form idea.

2022Nov14

ANmarAmdeen

Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

2022Jan5

ANmarAmdeen

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

ANmarAmdeen

IsPrime

Checks to see if a number is a primary number. Prime numbers are commonly found ...

2018Jul25

ANmarAmdeen