Search results 111

Sorted from new to old.

CopyDynamicRangeValue

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

2023Aug10

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

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

Cell_Add_or_Subtract

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

2022Sep1

SettingNameAlreadyFound

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

2022Aug18

BooleanCount

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

2022Apr22

Old cell value

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

2021Dec30

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

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

1 2 3 ...6 7