I am trying to update my sheet name based on a reference to cell a27 in the worksheet. Only thing is I don't want it to affect all tabs, just those in between my bookends aptly named first and last. I have tried working this on my own, stringing bits of already existing macros in my book, but as I am a novice (that's being generous) it is clearly not working. Can someone take a look below and advise where I am going wrong? I know I really suck at this so don't laugh too hard.
Also if anyone can offer any recommended reading on programming that would be most kind. Thanks a bunch.
Warmest Regards-
Kiki
Bookmarks