-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
name exists
-
L
Copy Template worksheet From List - adding new Names to List keeping previous sheets intact
Hi, I'm new to this site and VBA. I came across solution that works fine for me up to the point where I add new items to the list and then Macro tries to overwrite sheets that are already there returning error about the name being taken... what I have now: I have workbook with sheets "List"...- Loco1010
- Thread
- adding new items to list copy worksheet name exists name from list
- Replies: 2
- Forum: Excel Questions
-
If FILENAME exists in directory, save as FILENAME1 or FILENAMEx etc.
Looking for a way to automatically add a check digit (or whatever) to the end of a file name, if the filename intended already exists in the target directory. Here's my code, which works brilliantly if the filename isn't taken: Sub FinalProcessing() '////Sub 8//////'////Sub 8//////'////Sub...- Gingertrees
- Thread
- name exists save as
- Replies: 1
- Forum: Excel Questions
-
S
If Exists Name Function VBA
Hi, I have a VBA program that creates a report sheet using information from other sheets. This is done monthly. I would like to format the section total rows if they exist. Here is what is going on. The report pulls information from one workbook, and assigns names to a total row if said...- saschmeling
- Thread
- format name ranged name exists vba
- Replies: 2
- Forum: Excel Questions
