Similar codes

Card image cap
FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

ANmarAmdeen
Card image cap
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

Oct13

ANmarAmdeen
Card image cap
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

ANmarAmdeen
Card image cap
CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

ANmarAmdeen
Card image cap
CountColumnCells + CountColumnCells_Criteria

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

2018May23

ANmarAmdeen
Card image cap
ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

ANmarAmdeen
Card image cap
CellRead (SimpleLookup)

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

2018Jun25

ANmarAmdeen
Card image cap
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

ANmarAmdeen
Card image cap
ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

Dec23

ANmarAmdeen

Recently by developer

See more
Card image cap
FixURL

Return safe URL after converting critical chars to whatever passed in SafeChar

Mon 10AM

ANmarAmdeen
Card image cap
RegSave, RegRead, RegDelete

Windows Registry read, save and delete branch node or key. Three functions use ...

Sun 9AM

ANmarAmdeen
Card image cap
Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Sep10

ANmarAmdeen
Card image cap
Get boot time

Get the last time Windows 10 was started. Needed this quickly for research.

Sep6

ANmarAmdeen

Random Codes

See more
Card image cap
ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

Dec23

ANmarAmdeen
Card image cap
XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

Nov26

ANmarAmdeen
Card image cap
CSS Hover effect

Pure CSS hover effect From

2019Jun20

ANmarAmdeen
Card image cap
confirmDelete

Asks user before running a link (mostly before deleting) Small important part ...

2018Jun19

ANmarAmdeen