Search results 178

Sorted from new to old.

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

tag_add

Add to textbox from listbox (select option) ensure its uniqueness

2021Aug24

setSelectedIndex byname and byval

Set active (Selected) item in listbox using javascript Imported and modified ...

2021Jun10

ANC Bootstrap controls (Testing < and & # 6 0 ;)

Testing step in site (or in each HTML output function to replace < with < ...

2021Jun9

HTMLTagAttributeValue

Reads value of certain tag attribute from certain attribute Identify attribute ...

2021May30

1 2 ...5 ...11 12