Hi All,
As a follow on from my previous post a few weeks ago, this is the code I have at the moment. It works perfectly when I change the value in cell G7.
What I didn't account for was when you clear the contents of G7.
I want to be able to either have the tab name to stay as it was...