As I trying to get my coding better, I've been searching for advice regarding which is a better technique. More Modules, each with a unique name referring to the (perhaps) one to five related modules, or fewer modules with more routines in each module.
I have figured out it's easier to have a...
I'm struggling to find the answer.. probably because the way I'm wording the search.
I have a Main Sub Routine which in turn Calls various smaller Sub Routines.
in the 1st Sub I assign a name to the active 'main' workbook eg.
Dim workbooknamemain As String
How do I carry a variable forward so that its value can be used in another sub routine?
I have several routines that are identical except for the column they're affecting. Just before each routine comes to an end, I assign a value to a variable (the same variable exists in all routines) and I...
I have a Module that has worked for almost a year but is now not working. I've had to rebuild the worksheet because of a un-delete-able style issue that was causing confusion on the part of the end users. So I copied this module into the new workbook.
Here's a sample:
Sub VehInv() cntYear...
Hello, i want to know how it is possible to have an automated routine that will archive the workbook and will create a new workbook ready for entering the new data.
Any method of doing this would be greatly appreciated!