Search results 63

Sorted from new to old.

MathInsideText

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

2025May8

Tabs-Auto-To-Menu

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

2025May4

MatchIf7Up

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

2025May3

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

2025May2

ANmaUploadFTP_FilesListto1Folder

Creates script to upload list of files found in column. Will upload all files ...

2025May1

FirstDuplicatedItem

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

2025Apr18

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

2025Apr17

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

2025Apr10

DateAdd_Networkdays

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

2025Apr6

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

2024Jan30

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23

USB Format in Car stereo

What format used to let Car stereo read USB thumb drive? To listen to MP3 ...

2023Sep29

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

1 2 3 4