Search results 183

Sorted from new to old.

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

Range_Add_or_Subtract

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

2023Feb18

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

ANmaVLookup

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

2022Dec23

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

SwapNumbers

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

2022Oct17

Cell_Add_or_Subtract

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

2022Sep1

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

BooleanCount

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

2022Apr22

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

1 2 ...5 ...11 12