Search results 199

Sorted from new to old.
Card image
EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...

Card image
Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

Card image
Convert_Dash_to_Zero

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

Card image
Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

Card image
FontAwesome icons in Office apps

Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...

Card image
MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

Card image
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

Card image
SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

Card image
Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

Card image
RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

Card image
ANmaRemoveDuplicates

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

Card image
ANmAdvancedFilter

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

Card image
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

Card image
SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

Card image
Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

Card image
ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...