loops

I have a small table and some code which shouls extract the Generic Category value for each row and then use that Name value to greate new worksheets with. My table: and my code: Sub CommandButton1_Click() Dim cProduct As String Dim myRange As Range Dim sCell As Range Dim copySize As...

Hi All, I have the following data in column A of a worksheet starting from cell A1: Column A Column B ====== ============ xxx ABC xxx 123 4567 876 I am looking for VBA code that will colour the cell in column B in yellow if the cell to the left in column A contains "xxx" or...

I am unsurea bout why htis is not working and giving me a type missmatch error Private Sub SubmitCSR_Click() Dim LastRow As Long Dim ws As Worksheet: Set ws = Sheets("GP count") 'declare a variant array Dim ReceivedV(1 To 6) As String 'populate the array ReceivedV(1) =...

I'm trying to write some code that deletes the unspecified columns based on the header and for one reason or another the code does not execute. wbDest.Activate lastColumn = Cells(1, Columns.Count).End(xlToLeft).Column For i = 1 To lastColumn If Cells(1, i).Value <> "Ordered...

Hello, I currently have thousands of folders with each of them having up to 10 .jpg image in them. My goal is to create a macro that goes over all folders, and for each of them, converts all .jpg files inside it into one PDF (1 img/page). I have successfully made the macro for one folder, so...

Hi, Using Excel 365. How do I evaluate a variable at run-time? The code below is returning sp1, sp2, sp3 I am trying to evaluate the variable as Alpha, Bravo, Charlie, Thanks -w Sub foo2() Const sp1 As String = "Alpha" Const sp2 As String = "Bravo" Const sp3 As String =...

I have a log that keeps track of what documents my employees have read. When they have read one in person, I manually change the color of the cell in my workbook. Then I have a macro that will look for any cells with the same document name as its value and will match the color. I want to be able...

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

Hi all, I need help with an excel macro. I have only started to use macros and as a result have a very basic knowledge and understanding. I was wondering is it possible to create a macro that can be reused even when the raw data coming in changes the position of the cell that the macro was...

Sub Case_Automation() Dim a As Long Dim b As String Dim c As Long Dim d As Long Dim e As Long Dim f As Long Dim g As Long Dim h As Long Dim z As Long Dim j As Long Dim k As Long For z = 10 To 50003 a = Cells(z, 8).Value b = Cells(z, 27).Value c = Cells(z, 14).Value d = Cells(z, 18).Value e...

I have two workbooks, one with the Code INSIDE of it Sheet1 (which is the codename of the sheet I want to copy values from) and another workbook defined as "y" in this example. I want to copy over the values of cell "K1-K10" in Sheet1 into cell ("F1-F10") of workbook y (For example, I want...

Hello. I know this has to be answered before but I couldn't find anything in the forums. What I am trying to do is this...I have two named ranges, LR and LR2, each on a different sheet. I'm trying to create a If and For loop that would go through range LR and match it with a value in LR2 IF...

Hi Guys, So I have a VBA macro which I can rearrange data with but need some help to make it more efficient. So i have a lot of source data (~900,000 rows), populating A2:AD900,000. My code works down column AM which is populated with names. So the code takes the name from AM2 and loops down...

Hello, I'm a new VBA user and really need some help. I'm trying to perform pairwise permutations of an undetermined number of values entered along a single row. The permutations should be exported into columns A and B in another tab. Then I want to repeat this process for the next and all...

Hello guys, I sometimes have for loops nested in for loops, but once i find my answer id like all of the loops to exit, not just the current one. My current code looks like: For Each item1 In fulllist1 For Each item2 In fullList2 If item2.Text = "hit" Then done = True...

I keep getting a "subscript out of range" error on the If statement. I've tried changing the start index to 0 and 1 and it still had this error. Sorry the codes messy, part of the reason I've been messing around with a lot of different ways to declare the array. I'm trying to alter values of...

Hi, I am writing a program in excel VBA where I want to write two for loops together. For example, For x = 1 to 10 and For y = 1 to 10 do something ... Next But if I write "and" between two for statements the program shows error. If I put : between the for statements or write them...

Sheet1 of workbook A, containes a column listing file names stored in a specific folder and two columns over the corresponding row contains a number. This number represents the number of times i need to copy and paste the data in the corresponding file onto sheet 2 of workbook A. A...

This, I thought would be easy... I'm still very much a novice but I've been learning and I can do it with array formulas so I thought, VBA shouldn't be a problem... one whole Saturday later. I have a very large and growing range of data, Sheet("Tally"), the source And another...

I imagine this is painfully simple, yet all my research and trying to figure it out on my own has led to failure. I've learned how to create a button in Excel and create code in VBA to have that button change cell values. The problem is that right now I only know how to affect one cell at a...