Search results 127

Sorted from new to old.

HTML_CountTags

Counts how many certain tag found in an HTML block. like how many tr found in ...

Fri 5PM

UsedRange

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

May12

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

May12

Tabs-Auto-To-Menu

Turns tabs into menu based on available width. JS (Bootstrap 5) code to turn ...

May4

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Apr18

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

Apr12

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

Mar24

ToggleCells

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

Feb2

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

SSL/TLS certificate add/update

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

2024Nov7

Sheet_RowID_Generate + _LastUsed

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

2024Nov3

1 2 ...7 8