I am using this formula
=CELL("filename")
which produces this result...
C:\Users\Glen Munro\Dropbox\_VBA\___ MY BIG TEST\[to delete duplicate.xlsm]Sheet1
I would like to produce this result
C:\Users\Glen Munro\Dropbox\_VBA\___ MY BIG TEST\to delete duplicate.xlsm
I am solving this with a couple...