User Profile
A_SIRAT
Iron Contributor
Joined 7 years ago
User Widgets
Recent Discussions
- 53Views1like0Comments
- 891Views0likes0Comments
- 839Views0likes0Comments
Help Edit a vba code
Hi, I got this code from the Internet which works pretty well. However, I would like to create an exception in what it does. The vba code renames the sheet names using a specific cell value. I need the code to be edited so it will also omit a sheet name that I do not want it to be renamed. At the moment, if there is any valid value on Cell F3, renaming will occur. If cell F3 is blank or >0, then it will give a message that the specific sheet has not been renamed.... Thanks in advance.Solved791Views0likes2Comments- 888Views0likes0Comments
Please help with a simple VBA Macro
Hi, I have a file that I would like to have a macro that will clear the contents of cells E18:F19 on all the sheets except the first sheet named " Action". I have sampled two sheets but they could be more than that. These two cells are sent with data that is not compatible with my other program and I have to manually clear the cells. The file has two macros running perfectly doing other things. thanks in advance.Solved964Views0likes2CommentsRe: Help to consolidate Data into one sheet.
Lorenzo Thank you very much. I have done a few tests and it works perfectly 🙂 Would you be so kind and help me with the last request. I have just thrown a spanner in the works by adding a column named Master Data where I have indicated which varieties are divisible by 200 and others by 100.3.2KViews0likes5Comments
Recent Blog Articles
No content to show