Return filename only
Function to extract filename from path & filenameAuthor: michael@excelexperts.co.uk
General
Select a file
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 …
Select a folder
Allows user to choose a folderShows the user a familiar ‘explorer’ type dialogue boxAllows the use of a ‘start’ folderAuthor: michael@excelexperts.co.uk
Leftmost worksheet in view
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 …
Get the last column
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 row
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 …