for...next

  1. A

    For...Next Loop Sticking

    I am using the following code to delete the header from each worksheet in a large Excel workbook. The code is running fine until it gets to one specific worksheet, then I receive the following error message: "Run-time error '1004': Select method of worksheet class failed". I have inserted this...
  2. A

    generate ID variable using multiple conditions

    Hi! I'm a beginner at VBA and I need some help. I'm using three data sets with district data. Some district have the same name so I want to apply an ID number instead of using the district names. I have a numeric ID in one of the data sets. I now want to insert that ID in the two data sets...
    • Alvina
    • Thread
    • for...next generate list multiple criteras multiple if vba
    • Replies: 1
    • Forum: Excel Questions
  3. Y

    For...Next: Next c not advancing through the range.

    The copy and pasting is doing what I want, but I'm having trouble advancing to the next cell in the Quantity column, to repeat my copy and paste. Eventually (when I stumble through this problem) I will need to do the pasting of the data from my 'next c in range' to the next row on the Invoice...
  4. X

    Excel 2010 VBA - How to - select multiple cells, then select .entirerow for each cell.

    What I am trying to do is tidy up an Excel report by deleting all the unwanted rows of data. Range("1:1").Find(what:="MCCR*resp*", lookat:=xlWhole).Activate Range(ActiveCell.Offset(1, 0).Address, ActiveCell.End(xlDown).Address).Select For Each cell In Selection If cell <> "ASPF" Then...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top