loop and on error issue

I have a worksheet that can contain up to 40 worksheets with a name LIKE "AAA_####A" where A can be any letter and # can be any number. I am trying to loop through each one in turn, extract data, paste it on another worksheet then go to the next worksheet. The code below is where I am, but it...

Long time reader, first time poster! I'm trying to create a Loop that names a sheet based on a cell value. If the sheet name already exists then the macro will pop up a message box with an entry field to enter a new name and that will Loop until the user enter a sheet name that isn't already...

Hi all, I want to export a group of shapes as an image. The group consists of various shapes that are displayed / hidden based on user selection and show incident types on a map. All I want is to export this map to a JPG. I have crafted a script from various finds online, it works sometimes...

Maybe someone can help me with this? I have a loop going through a column to see if anything is not zero. If there is an error in one of the cells I want is to go to the error handler and perform a set of statements. However, I'm getting issues with the loop not ending as the variable will not...

Hello, I am trying to write VBA code that will open a file with the following name: "Price Overrides" However, sometimes the name of this file is "Price Overrides-1", or "Price Overrides-2" depending on when I lasted open/closed my browser/excel which can be hard to keep track of sometimes...

I have searched the web all day and have not found an answer. I have two workbooks. One is created at the begining of the year and the other is used to update it each month. I have a loop statement that has an on error goto label. The first two tabs in my main workbook are not in the new...