Search results 52

Sorted from new to old.

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

OutlookFolder_DuplicatesCount

Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...

2022Dec31

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

FoundinList

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

2022Aug12

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

2021Mar10

2 VB.net pdf books

Free from apress website https://www.apress.com More books

2021Mar2

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

2020Oct11

1 2 3 4