I have a basic custom function to include the full file path and name in cell like such.
But when I either move or rename the file, I want the cell value to update to the current folder/file name structure automatically. And I only want to update this one specific worksheet or named ranged, and not the entire workbook as it slows down the opening of the file. I've tried using the below in the workbook module but it does not update the cells.![]()
Please Login or Register to view this content.
I did try changing the above to use CalculateFull and Excel throws a run time error. So what is the trick to updating a selected worksheet or named range in VBA without updating the entire sheet?![]()
Please Login or Register to view this content.
Bookmarks