for next

  1. R

    Help with worksheet_change

    I am trying to display a msgbox if a user selects certain options in a dropdown box. Here's the scenario. This is for a scheduling assistant I am building. Daily schedules have several cells with a dropdown lists that refer to the entire staff. I know the staff's availability, so I have...
  2. L

    Check value exists update it or add it

    Hi Everyone, I have issue with VBA with For next loops and verifying data. Right now this macro does 2/3 of what I want, but I cannot get it to add the row on the end if it does not find it. My goal is to check wb2 column "k" values against wb1 column "k" values and update if its their, and...
  3. VBE313

    UDF Loop Freezes Unless Calculating in The Sheet it’s in

    I have multiple UDFSs that loop through cells, I have application.volatile on them with worksheet change events that calculate the sheet. But if I am in a different sheet and press calculate, it freezes. Any suggestions?
  4. D

    For Next with Step Loop missing last value..sometimes

    Hi name is Doug. I have been dabbling in VBA for a couple years and probably been a guest on here a bunch of times. I am new member today! I have some code to fill in a bunch of cells with number incremented by a specified value. It is pretty basic stuff but I have found that it...
  5. R

    Need Help Please

    Hi guys, i need help. i want to do copy-paste diffirent worksheet but with for next loop for example: Worksheets("Sheet1").Range("a1").copy = Worksheets("Sheet2").Range("a1").copy Worksheets("Sheet1").Range("a2").copy = Worksheets("Sheet2").Range("a2").copy etc... Sheet1: Sheet2 i have...
  6. R

    For Each Next Help

    Need a little help with writing a For Each Next loop. I have a set of data on Sheet2 with names in column A, dates in column B, addresses in column C, city in column D, state in column E, and zip in column F. Ideally I need an input box to pop up, the user enters a date and then for every person...
  7. R

    ComboBox HELP

    Hey all, I have two questions... 1.) Is it possible to select multiple choices within a ComboBox? Is it possible to select multiple choices within a ListBox? If so, how? 2.) Assuming it is possible to make multiple selections, I have a list of names in Column A, a list of their respective...
  8. D

    Worksheet check macro sub-routine

    ;) Greetings! I searching for assistance in writing a VBA macro that will check each cell in a range for the existence of a specific text string "Mismatch". If the text string exists a Msgbox "Mismatch Found!"; if not Msgbox "Worksheet Checks Good!" would appear. Worksheet: CREW30 Range...
  9. J

    Compile error "Next without For"

    Hi there, When I run this code I get the compile error "next without for" and I can't figure out why Sub Find_Class_A1_then_Hide() Application.ScreenUpdating = False Dim r, Lastrow, cLastrow, tRow As Long Lastrow = Cells(Rows.Count, "A").End(xlUp).Row For r = 1 To Lastrow cLastrow = Cells(r...
  10. D

    For Next Faster

    Hello, I am using the below code. Is there is a way to have this go faster? Or some way for as soon as it finds the correct cell, to go to next? I am searching through about 1600 cells and 1600 cell2s. I am still new to VBA, any help would be greatly appreciated. For Each cell In...
  11. M

    Default Skipping an i, or multiple i's in a Loop - please help

    I am writing some code to generate multiple pivot tables in excel. My spreadsheet is set up with survey responses to a variety of questions with the question number across the top, and the survey responses below in the column. My problem relates to questions 8, 10, and 13. As you can see in my...
  12. N

    VBA create table from existing table selecting rows based on values

    I need to create a new table in excel on the existing sheet "ScratchPad" by pulling rows from the existing table named "ChemItems" but I only want to pull the rows if a value is populated in the column "Sale Price". Here is an example of the ChemItems table: <tbody> Item Name Sale Price...
  13. X

    Using For Next to delete unwanted rows, but only deletes half at a time???

    So what I am trying to do is delete unwanted rows in one Sheet if they do not meet the validation values from 2nd sheet. I have a tag list with tags that are associated to a system. Some systems are not part of the project so I need to purge these from the excel list before I can run a status...
  14. C

    For Next with variable

    A member of MrExcel was kind enough to help me with the code below. One thing it is lacking is the ability to manage a variable # of columns and rows. I would need to account for that possibility. My thanks for your help! Sub Foo() Dim MyDay As String Dim MyCol As Long, i As Long MyDay =...
  15. S

    Loop through Worksheets

    Hello! I want my code to loop through the worksheets so I used For each-Next,. but it brings up an error "invalid next control variable reference". I have more to my code but for space and time saving I have removed the more lengthy parts. Any help would be much appreciated! Code: Dim...
  16. F

    R1C1 And looping

    Hello everyone! I am quite new at VBA and my boss assigned me a project that requires me to calculate the average, Ann ROR, and standard deviation of various funds using a For Next loop. The spreadsheet given to me has 331 rows and 180 columns. My boss wants me to use Finalrow and FinalColumn...
  17. J

    Loop through multiple ranges

    First off, thanks for looking at this. I am having a problem trying to figure out ow to move to the next set of cells. I have a list of data on say Sheets("Sheet1") that I need, starting in BA8 that goes down 6 rows to column DW. I need to loop through each columns set of six cells, copy and...
  18. V

    Offset and for next

    Hey all, I have a code that I am trying to expand to a range of about 20 rows by 2 columns. I would like for the macro to loop (?) through the entire range and offset each cells of the range 10 columns right, & 100 rows down. Public Sub lmtpastespecial() ActiveSheet.range("a4:b4").Copy...
  19. R

    Skip Mismatches maybe with Do Loop or For Next

    I'm trying to pull data into a template from a source tab matching by account number. However, having trouble when the account numbers in the source tab are not in the template. If its just one account number, or they are separated by good account numbers, the code below works, but if 2 or more...
  20. A

    Using ADO to add data to fields with similiar name.

    I have a table, name myTable in access database in desktop\jwb.accdb. the table has more then 50 fields. the name of the fields: answer1, answer2,....answer50. And I have data in excel column A1 to A50 that I want to add to these fields. data in A1 to answer1 data in A2 to answer2 data in A3 to...

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
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 "".
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