Search results 188

Sorted from new to old.

UsedRange

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

Mon 1PM

1st cell of sheet range

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

Mon 1PM

Custom Excel UI ribbon

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

Sun 2PM

MathInsideText

Return string after applying math to each number found inside the string. ...

Thu 1PM

ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

Apr19

FirstDuplicatedItem

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

Apr18

String_Fx

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

Apr10

String_S

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

Apr10

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

Apr6

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Mar12

ToggleCells

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

Feb2

ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Jan12

YoutubeLinks2YoutubeEmbeds

Convert all links in text block into youtube embeds to show inside a website. ...

2024Dec22

Domainer v2.4

FIles to host website for sale. This was originally from a source I found ...

2024Dec20

ConditionalFormatting_ColorARow

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

2024Nov10

ANmAddress_Dimensions

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

2024Nov8

1 2 ...11 12