
Originally Posted by
Whizbang
Go to "Tools" -> "Macro" -> "Visual Basic Editor".
On the left you should see a list of "modules". If not, go to "View" -> "Project Explorer".
In the Project Explorer, double-click on the module for the worksheet you want to have the autofill code in. It should look like "Sheet1(YourSheetName)"
In the white area to the right (it should take up most of the screen) paste the above code. Do not paste this inside any other existing sub or function.
Bookmarks