for cycle

Hi all, I currently have the following VBA code attached to a macro that sends out an email and attaches a word file to it when I click it and sends this out to a list of emails (and also BCC's a list of emails): Now I want to edit this file so I can target a list of emails in the emails...

I created this macro to count the number of rows starting from column B. Then I created a cycle to fill columns 3,4,5 and 6 with excel formulas. my problem is that the references should be relative and not absolute (b5,b6,b7 and c5, c6,c7...until the last line). I can't finish the macro. Can you...

Hello all, I have this code that does what it's supposed to, but it requires me to run the code several times, I am just trying to see what I can improve upon to make this code run completely the first time. Sub deleteNonBank() Dim R As Long Dim Lastrow As Long Lastrow =...

Hi everyone I'm working on a project and I want to work this macro code. This code running on a userform(with ADO but I designed activeworksheet the below code for tell) and effect another userform label captions. Anyway, the problem is after the code run erasing previous label caption. I...

I'm trying to speed up my code. I understand there are many, MANY combinations that I'm looping through but want to know if there's anything I can do to help. Sub casey() Application.ScreenUpdating = False Application.EnableEvents = False Application.Calculation = xlCalculationManual...

Hi I am trying to create a program in VBA where I have an Array A and I am trying to Iteratevely find the minimum value in the array, get its position in the array and next update its value to an arbitrary large number (say 9999). The code I have come up with so far is something like this For...

I am trying to write UDF in VBA that will give me a the y-coordinates to confidence bands for a linear regression of data. I am new to programming with VBA but I have scoured the internet in order to try and figure out what I'm doing wrong, but I cannot figure it out. I basically can't get the...

I want to iterate through a range of combo boxes with similar names and add items to the combo box. For i = 1 To 5 Set varComoBox = ThisWorkbook.Worksheets("System").OLEObjects("cbo" & i) With varComoBox & i .AddItem ">" .AddItem ">=" .AddItem "<" .AddItem "<=" .AddItem "=" End With Next I...

Hi I'm working with these kind of repeated codes. Private Sub Cmd1_Click() With Sheets("sheet1") .Activate .Visible = True End With End Sub Private Sub Cmd2_Click() With Sheets("sheet2") .Activate .Visible = True End With End Sub... Private Sub Cmd200_Click() With...

I am seeking a way to optimize some of my code, and have run into a wall I can't seem to be able to tackle. Actually I am seeking an efficient way of populating a dataset with a new column of calculated data. I have already exhausted my optimization possibilities with Application.ScreenUpdating...