newname

Hi, I have the VBA code below working perfectly on my PC windows: - Makes a copy of the required sheet (sheet 2 in this example) - Saves it as an xlsx format so all formulas and macros removed, just values and formatting kept. - Creates the filename using specified ranges given and file type...

Hi, I've referred to this site numerous times over the years and it has been very helpful so firstly I would like to say thanks. Generally I've not needed to post a question before as I have generally been able to use the information in the various posts to figure out what I have needed to do...

Hi all, I using a simple VB code that takes the name from a specific sheet cell and changes the tab name to match when that tab is activated. I want to expand on this macro to have a message pop-up if there is an error with the name structure. Like having the same name as another tab or if the...

Hello, I am a basic excel user who is just learning to do a few simple things in VBA and only through information I have found in searches (like adding auto-complete to a dropdown list). My company just moved their server and now a form a previous employee wrote is not functioning properly. I...