Search results 150

Sorted from new to old.

CopyFiles Excel-Macro

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

2024Mar12

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

2024Feb14

FindLinks xla

Excel Addon to find links in workbook. FindLinks v13.2 From

2024Feb9

Excel clipboard bug

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

2023Dec27

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

Fix Excel Issue

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

2023Aug1

Enable Blocked Macros in O365 from OneDrive

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

Excel user name

Get application user name or change it Originally from

2023Jun14

SubZero

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

2023May23

ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

2023Apr28

1 2 ...9 10