Search results 90

Sorted from new to old.

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

HTML2Str

Special version to convert HTML to string. Uses RemoveHTML, then after that it ...

2023Nov5

ANmaFilter3

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

2023Oct13

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

ANmaRemoveDuplicates

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

2022Sep25

LastRow_Remove

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

2022Aug16

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

CreateUniqueList

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

2022Apr26

1 2 ...5 6