Search results 45

Sorted from new to old.

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

2024Jul27

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

2024Apr17

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

2024Mar12

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

2024Feb18

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

CopyDynamicRangeValue

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

2023Aug10

Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

2023Aug1

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function with AI-generated ...

2023Apr3

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

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

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

1 2 3