ScrapeURL_ToSheet

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

Excel recovered files

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

Convert_Dash_to_Zero

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

Windows Common Controls 6.0

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

VisualBasic6-KB896559-v1-ENU.zip

NavigatePost

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

Antispam - Hiding textbox

Anti spam email web form idea.

ANStr2Range

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

SwapNumbers

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

HyperlinkFunction

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

Shape_Select_or_CreateThenSelect

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

Protecting VBA code

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

SQL Related posts

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