loop error

I have this code that deletes objects all with the same name, but once it gets to the end I get an error. Is there a way to either: A - stop the error from popping up at the end of the code. or B - Just have the code fade and delete all the objects at the same time Do While...

Hello, My macro was built to loop through data of an original workbook and break out the data into individual workbooks based on the value of one field. The code works perfectly for creating the workbooks but I can not figure out how to get each workbook to save and continue on to the next. It...

Excel 2003. I believe I've got everything working in the code up until: If rnGx = rnGy Then It loops once and then "Run-time error '424': Object Required" for the code above. Sub test1() Dim rnGx As Range Dim rnGy As Range Dim i As Long Dim xNum As Integer Dim yNum As...

im trying to work on a simple program that it will highlight all cells with a value of 5 or less and VB is not my strong point. The problem is it highlights a million cells in the column because empty is less than 5. this is the code I'm using. I fumbled through forums for a day to get this...

Hi all, I have a macro which contains three nested 'for' loops. Stepping through the code they all appear to work as normal, but when I run the macro the results stop halfway. I have been poring over the code for hours and cannot see why for the life of me. If anyone can spot an error or might...

Hi all- I'm trying to run a simple loop and I keep getting "compile error: Else without if" that doesn't make sense to me. Basically I'm checking a range for formulas and if there is a formula, I'll skip that cell. If the cell is blank, I'll enter a formula in an adjacent cell. Any help...

I want to look at a list of dated files and open them in order. below is my code. Dim loopcounter As Integer Dim rptdate As Date Dim datafilename As String Dim datafilelocation As String Dim fulldatafilename As String Dim fulldatafilelocation As String rptdate =...

Yet another up date can some one please tell me how I change this code so that when the conditions in each section of the if else block are satisfied that the “next” can see the “For” and not report the next without for if I can get this sorted then just maybe the other post will be come...

Hi Everyone, Im using the following code to insert multiple data in a single cell. For example: I choose a from a drop-down list (data validation cell) and it inserts the clicked item in the same data validation cell. '------------------ Data Validation add in same cell...