Trying to change a user input string

hi mrpwebb, welcome to Excelforum.

You need to use special code tags while posting any VB coding at the fourm as per the Forum Rules #3: http://www.excelforum.com/forum-rule...rum-rules.html

If to not get into the logic of your actions, it could be done this way (one of the options), press "Start" button

Sorry for the wrong formatting last time.

I will try again here.

The above code is causing a run time error '424' object required to appear

The reason behind wanting to get this to happen is that I am lazy and instead of starting 3/4 different macros and entering the same information with minor differences (which are the same for each sheet) I would like it to be automated.

I have included the whole code for this macro below. [hopefully correctly inserted]

Please Login or Register  to view this content.

Once again thank you for any and all help

hi there,

1. The code posted correctly in post #3, thanks. The code in post #1 is still missing correct format for code posted.

2. The code from #1 has error:

Please Login or Register  to view this content.

Set is used to create an object not a variable to hold string value in your case

3. The code posted in reply #3 is not the same with the posted code in #1. The code is OK in terms of running it from the start to the end.

Can you explain what exactly do you want help with?

Hi,

The code in #3 works.

I would like to change it so that instead of asking for another user input for the new 'master' sheet name it takes the init value and adds an 'm' at the end and uses that value as the new name

things to consider if user enters sheet name to use:
1. Sheet name length should be no more than 31 symbols
2. The following signs are not allowed in the sheet name: : \ / ? * [ ]
3. Sheet name can not be null string
4. New sheet name is already existing

For now it's not accounted for as I do not know what should be done in this case within your code logic events.

Please Login or Register  to view this content.

This code runs fine [no errors appear], however a new sheet is created which is called 'master (2)' and the data is not transferred.

hi there,

You get Master (2) sheet only in the case if a sheet with the same name exists.

Except for this code extract that has no logic:

Please Login or Register  to view this content.

I do not see any other reason for trouble. If the values are equal what is the point to check which of them is higher. Obviously none.

The sheet is created and named as per your request and data is transferred accordingly. Please check attachment with your code and amendment from post #6. Press Run button

This now works.

There was a hidden sheet of the same name. (My fault)

The check "C" was also an error. The second check was meant to be "K" a date and delete the older entry.

Thank you for all your help.

Hi there. Are we done with it?

Yes. Thank you again.