Search results 103

Sorted from new to old.

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

XMLRead

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

2023Nov26

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

CopyDynamicRangeValue

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

2023Aug10

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

Cell_Add_or_Subtract

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

2022Sep1

SmartMenus for WordPress

Cascading menu, on all devices. From ...

2022Jul11

1 2 3 ...6 7