Search results 148
RangeTakePicture_Linked
Converts a range in Exce lsheet into picture. linked or unlinked. Important ! ...
ShapeCreate_SomeVariables
Create a shape in certain sheet with options Some other options are hard-coded, ...
Calculation_StaleValues
Show Stale function formats or hide Excel recently started to show cells with ...
Header font name and size in VBA
Looks like it is not easy to change font name, size and style for a header or ...
Custom Excel UI ribbon
Excel custom ribbon in details. A good article I use as reference to add custom ...
VBA/Excel Registry hacks
Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...
ANmaRemoveDuplicates2
Remove duplicated rows based on 2 columns in a table of any number of columns. ...
ANmaRemoveDuplicates4
Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...
ANmAddress_Dimensions
Detects how many dimensions an address has, This is what I call it dimensions ...
Unblock blocked macros.
Unblock macros in file copied or downloaded from another machine. Excel keeps ...
CopyFiles Excel-Macro
Simple macro to make sure we have a copy of all files in a folder found in ...
Send workbook as email attachment
Retro way to send a workbook you are in as an email. Found it in one of my old ...