Here is a simple way to target a cell's value and divide by 7 cellv(col-3,row)/7 This will target the 3rd...
how to
This a quick simple way to show how to use buttons to navigate the on the to different worksheets. From...
Moving on from the Computer beep from excel, this code will play the Mario Theme song, now it isn't 100%...
Annoying, or clever, you decide how you use it! When Excel is opened, it sets a variable (Close_Var) equal to...
This code works along the same as the First and Last Month Dates but is for a rolling 12 month....
You can add a Data Validation list based on the value of another cell. For this example, it uses the...
This will check each question entered into the script and if answered will +1 to the starting figure of 0...
Date picker, has to be X days in the future from today Exact date is a picker for the user,...
Capture IP addresses This script will pick up the IP address of the user and set the rendering mode -...
This handy bit of code will let you email someone defined or selected and have them come into a call...