loop code in row

Hi, How can I edit this code to repeat the check on the next row? I would like the code to check ranges B3:B9, B12:B18, B21:B27, B30:B36, L3:L9 before closing to ensure that the user cannot close the form before editing all cells. I should note that usually only one row will be completed at...

I can't figure out why the code below will not loop. It's supposed to go through all the rows in the spread sheet and delete any rows that say "Yes". But currently it will delete the first row that has a "yes", then it stops. No error, it just stops. I'm guessing it has something to do with...

I have a lot of ranges I need to name. I want to use VBA to name every range in a column by referencing another column that contains the range names to be used. For instance, I want to name cell E3 (which has a value of 1) with the name in cell A3 (JillJan). Then, name cell E4 (which has a...

Hi All Take a look at the example table below. <tbody> Row Age Age Multiple 1 17 0.8 2 20 1.0 3 25 1.15 4 35 1.20 5 50 1.22 6 70 1.23 </tbody> <tbody> Age x Age x Age Multiple ? </tbody> If I have a variable "Age" on the sheet (populated from a UserForm) I need excel to...

I am trying to write a macro to copy each line from columns A to E and paste each row 3 times on another tab. I need this macro to loop through until it hits a blank row. Here is code that I recorded, but I do not know how to make this into a loop. I also have a piece of code that grabs F to I...

Hello, I'm trying to catch a weekly task in a vba code: calculating the work days between date of delivery and date of return. Sometimes, I do not have a date of return and in this situation the code should loop to the next y. The error I got back is 1004: "Application-defined or...

Hi all, In need of some help as I'm a bit of a vba novice: I have a worksheets (entitled Summary 1, Summary 2, Summary 3 etc), I want to loop through the cells within each of the summary sheets and every time I come across a number, I want to copy that number into a new worksheet (entitled...

Hi, I have coded a macro that effectively copies a dynamic named range to a sheet called Sales chart. The working named range, called ItemsSold, is a single column consisting of uniquely filtered data. My problem is the second named range; I want it to look up the source data, called Sales...

Hello. I'm trying to write a simple macro that loops through each row a data on a single sheet. If the value in Column C is "Percent" i need to select range "D:M" on that row and convert the number format to percent. If the value in Column C is "Dollars" in need to select the range and convert...

VBA - Create New Worksheet from list I need some excel 2012 VBA help please. Table2 in the worksheet named "Index" has employee information. The code below reads the list and creates a new worksheet and renames it based on contents in column e and increments to the next This code works for new...