Search results 60

  2. Search results
  3. ShIn sheet name in VBE
Sorted from new to old.
Card image
MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

May3
Card image
String_S

Generate repeated text, like String() the function but with ability to repeat ...

Apr10
Card image
Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3
Card image
ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11
Card image
Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23
Card image
ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23
Card image
ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21
Card image
SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3
Card image
Dark bootstrap5 css

Css and scss for dark Bootstrap 5 theme Made using

2023Jul26
Card image
Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25
Card image
IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24
Card image
Convert_Dash_to_Zero

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

2023Mar14
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
FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12
Card image
ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24
1234