Search results 59

Sorted from new to old.

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

Nov3

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Oct6

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Aug20

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

Aug7

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

Jul26

MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May31

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

Jan14

ANStringListRead_JSON

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

Jan9

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

ReverseArray

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

2023Nov27

Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

2023Oct17

Web.config redirect

Redirect URLs to certain page passing its name. This is web.config from one of ...

2023Aug5

List_of_Names + DeleteNames

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

2023Jul9

Excel user name

Get application user name or change it Originally from

2023Jun14

Filename_Clean

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

2023Jan11

1 2 3 4