Search results 146

  2. Search results
  3. Form
Sorted from new to old.
Card image
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11
Card image
ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5
Card image
ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2
Card image
ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27
Card image
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14
Card image
Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7
Card image
Range_Add_or_Subtract

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

2023Feb18
Card image
Antispam - Hiding textbox

Anti spam email web form idea.

2022Nov14
Card image
Cell_Add_or_Subtract

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

2022Sep1
Card image
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24
Card image
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22
Card image
ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4
Card image
Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16
Card image
ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

2022Apr21
Card image
DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11
Card image
DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3
123...910