Search results 248

Sorted from new to old.
Card image
ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

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
NavigatePost

Reads content of webpage with optional post data two main differences from

Card image
Antispam - Hiding textbox

Anti spam email web form idea.

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
HyperlinkFunction

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

Card image
Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

Card image
Protecting VBA code

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

Card image
SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

Card image
OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

Card image
AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

Card image
SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

Card image
UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...