Search results 47

Sorted from new to old.

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

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

ShowImage

Show an image using irfanview or Windows 7 image viewer. Looking to add more ...

2020Feb16

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

2020Feb5

HasDups

Indicates if an array contains duplicate values. returns True if more than one ...

2019Oct5

CSS Card effect

CSS Card Hover animated effect From

2019Sep30

1 2 3