Search results 312

Sorted from new to old.

ANmaRemoveDuplicates

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

2022Sep25

ANmAdvancedFilter

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

2022Sep15

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

2022Mar3

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3

1 2 ...9 ...19 20