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