Search results 167

Sorted from new to old.

XMLRead

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

2023Nov26

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

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

Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20

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

SubZero

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

2023May23

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

Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

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

1 2 ...4 ...10 11