Hi,
I need to check when one of the values in the column is equal to a worksheet that is currently in the excel file. Just a message box that says something like “A worksheet currently exists with the name of a value in this list. Please rename the current worksheet”. When the user gets the message box, they should be able to click “OK” and the function ends.
Is it possible to modify this code?
Thanks in advance!
Please Login or Register to view this content.
Last edited by narendrabr; 02-11-2014 at 12:39 AM.
can you attach a sample file ?
you can use this code
Please Login or Register to view this content.
Last edited by patel45; 02-11-2014 at 02:43 AM.
If solved remember to mark Thread as solved
Hi
I have attached the macro enabled sheet.
can you please modify the code to solve the above stated issue?
Thanks!
Basically the execution should stop when the sheet name already exist and ask a message to rename the sheet with different name.
Thanks
try this code
Please Login or Register to view this content.
Can you please modify my original code in the attached spreadsheet.
Thanks!
I can not understand your code
Basically the code is splitting sheets based on column values.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks