Return filename only
Function to extract filename from path & filenameAuthor: michael@excelexperts.co.uk
Return filename only Read More »
Function to extract filename from path & filenameAuthor: michael@excelexperts.co.uk
Return filename only Read More »
Allows user to choose a fileShows the user a familiar ‘explorer’ type dialogue boxAllows the use of a ‘start’ folderAllows the developer to define the
Allows user to choose a folderShows the user a familiar ‘explorer’ type dialogue boxAllows the use of a ‘start’ folderAuthor: michael@excelexperts.co.uk
This ensures that the leftmost worksheet is always in view.Simply ‘call’ it from a procedure as required.If you have a ‘Control’ sheet containing end user
Leftmost worksheet in view Read More »
This is the function l have been using for many years to return the last row.It suits most of my needs as the parameters allow
Get the last column Read More »
This is the function l have been using for many years to return the last row.It suits most of my needs as the parameters allow
This is an example of a message presented in the event of an error being raised in the ‘NEW_Procedure’ procedure.Please edit to suit your requirements.Author:
New VBA procedure; error message Read More »
This is the code framework l use when building a new procedure. It includes error handling and timers.’ My approach is to include everything at
Starting a new VBA procedure Read More »