Search results 49

Sorted from new to old.

ANmaDropdown Search

Shows drop down menu of matching items when user searches in textbox with ...

May13

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

May12

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Apr18

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

Apr17

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

Apr6

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

Mar24

ListItemText_to_ListIndex

Finds the index of an item in listbox (or combobox) It searches for that item ...

Mar24

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

2024Jul27

CopyFields_FromTo

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

2024Apr17

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

2024Mar12

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

2024Feb18

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

2024Jan9

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

1 2 3 4