Search results 52

Sorted from new to old.
Card image
ANmaFormatLastRow

Format last row found/added in Excel range to certain color. ColorText is the ...

Card image
Textbox_PartialBold

Set part of textbox to bold, starting from StartingChar (like : ) that found in ...

Card image
Formulas_FromRow_toFile

Exports all formulas in a row of sheet into text file.

Card image
ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

Card image
UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

Card image
Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

Card image
HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

Card image
ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Card image
Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Card image
Match6_Until

Searches for six values in six columns and return the row number if all found, ...

Card image
FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

Card image
Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

Card image
SSL/TLS certificate add/update

Always found myself struggling when applying security to websites for the past ...

Card image
Sheet_RowID_Generate + _LastUsed

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

Card image
Get boot time

Get the last time Windows 10 was started. Needed this quickly for research.

Card image
Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...