Similar codes

Card image cap
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

Card image cap
SortArea1

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

2018Jul4

Card image cap
CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

Card image cap
CopyFormat

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

2018Aug10

Card image cap
Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

Oct7

Card image cap
SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5

Card image cap
SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4

Card image cap
RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

Card image cap
SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

Recently by developer

Card image cap
ANString_Location

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

Tue 8AM

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

Card image cap
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

Card image cap
CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

Random Codes

Card image cap
Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

2022Jan29

Card image cap
EnvVar_All

Read all Environment variables using EnvDir_All Or quickly get user folder, or ...

2018Jun17

Card image cap
BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14

Card image cap
FindSheet

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

2018Jun7