Excel VBA For Loop Example 1

[@TutorialsPoint_]

Get Certified in Excel VBA:bit.ly/41fWeVP
Use coupon "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@rwamukaagafrancis1204]

It took me so long to get such a great channel! I like every presentation!

[@jamesperry3837]

*Simple but you've made the video interesting. Thnx.*

[@alex20776a]

Simple and down to the point

[@kamerchan]

Thank you very much. Very clear illustration and excellent explanation skills!

[@ORANGEPICTURESOFFICIAL]

sir....do more videos on vba in realtime purpose................teaching is excellent

[@NishantSingh-qf4bf]

Sir mine is showing value of x

[@preetikarayat9616]

Thank you very much for your effort.

[@gauravdhawan1718]

Please help me how do I filter the cell using VBA code if the cells contains a number at the fourth place after a string.

[@SHIVAKUMARSOMA06]

Sir , I have vba code when I paste in module then I run excel for online update ,it won't run why ???

[@sudhasree8217]

Excellent I tried some codes I am getting compiler error "Loop with out do" can it be solved

[@AdityaRaj...]

you are great....

[@dhanuryapatel8310]

I like your English voice

[@muditrustagi5775]

how to open forms in a loop? please help

[@mohdrayees7297]

Dear sir
I have a value in one colum like (a1:a5) 12345 and in another colum (b1:b5)25410 so I want to match two value if they are same in one sheet and colour that cells

[@LesMiserables999]

Very helpful, thank you

[@nadeemakhtar1982]

Sir I want to combine some Excel files into one file.
How can do it ???
Please guide me

[@loading.m4469]

OMG u r sooo good u helped me alot😄

[@theknowledgejunction5338]

Simple for loop
ua-cam.com/video/wE5hGXP7hA0/v-deo.html

[@anshulgoyal934]

Thanks for this amazing video. have you upload ay videos where how to send email from excel, if yes, plz share link

[@sos_hodad]

You helped me out so much! Thank you!

[@smartrhi]

Thanks for your great presentation.
Could you let me know the software you use to make that presentation. You just stand in front of your presentation but you can click any button. Thank you for your kind attention.

[@dikahitech1]

Yeh! Please share

[@kannu5039]

My rename bar is missing, how do i get it?

[@amalkantideb4662]

Thanks a lot. I just picked up do while loop from your video. I want to use the value of 'i' from one sub procedure in multiple other sub procedures. Can you please help? To clarify I am adding the code I made:
Sub test_count_rows()
Dim i As Integer
i = 2
Do While Sheets("MAIN").Range("B" & i).Value ""
i = i + 1
Loop
End Sub

[@zakimaaz]

Awesome presentation.
Thanks a lot.

[@Roymanihuruk]

Can be given script for text box control, after run text in text box, the result is not different from text box, my problem is in multi-line suda control text box, but when sent the result so enter (VbcrLf) or new Line, I requires in function text box control (Alt + Enter) Or Shift + Enter runs so that the text you want to send has a new paragraph in the same line in the text box
Please help me

[@loading.m4469]

Great presentation! Thank you very much for your effort.

[@saupham8192]

Can you show me how to make a loop : for i=1 to a variant by user enter a number.
Thank you Sir

[@taimoorkhan8203]

I have a question
I need to run a loop and here is the situation
if value in range "C5:C10" (on control sheet) is 1 then shift to second last sheet (Named target sheet), copy a table named "Hyp_table" and paste it in a cell on target sheet, and the refernce of cell is in control sheet present in "D5:D10" next to the range on which I am performing the loop.
here is the code...
________________________________________________________________________________________
Sub testing_2()
Dim rng As Range, cell As Range
Set rng = Sheets("Control").Range("C5:C10")
For Each cell In rng
If cell = "1" Then
'Moving to my target sheet which will always remain second last while other sheets may be added
Sheets(Sheets.Count).Select
ActiveSheet.Previous.Select
'Copying my table
Application.Goto "Hyp_Table"
Selection.Copy
'Selecting my cell on "Target sheet" based on value in "Control sheet" and here is where I am facing problem
'I am still on my target sheet but I am selecting cell range from Control Sheet
ActiveSheet.Range(Sheets("Control").Cells(5, 3).Offset(, 1)).Select
'Pasting the table where the cell is selected as above
ActiveSheet.Paste
Application.CutCopyMode = False
Else
End If
Next cell
End Sub
_______________________________________________________________________________
The only problem I am facing is that I cannot make cell(5,3) dynamic, I need 5 in the Cell(5,3) dynamic, that once Cell(5,3) was checked for value, on next loop it should check for Cell(6,3), if the value is 1, its should perform copy pasting of table
Can you help me out on this.

[@theknowledgejunction5338]

ua-cam.com/video/wE5hGXP7hA0/v-deo.html

[@allampatinagaraju7985]

Excellent

[@saransinghraja2625]

Thanks for teaching please share excel sheet

[@sergei-aleinikov]

Thanks from CIT381-02 Business Intel and Analytics #BYUI, saved my time! (Thu Oct 10 546am)

[@oguzturkyilmaz543]

Thank you very much.

[@yangcao5114]

2:34 the guy for confused with the 11th msgbox showing up LMAO

[@krishj8011]

Nice video

[@jaswantdn7]

GREAT SIR...

[@briancowan21]

How

[@parmarboyz]

Really informative video but What if I want to run a macro multiple time instead of msg box and the for the length of the Loop I need to a refer to a cell. So that it'll run the loop for the time I have provided the value in that particular cell. Thank you in Advance !!!!!!!

[@tomzor83]

Mate thanks for simple explanation of this topic. But Your akcent is killing me ...

[@saxenarachit]

What is dim?

[@bulletbot1486]

example: Dim Untitled = "Untitled.mp4"
AxWindowsMediaPlayer1.URL = Untitled

[@Mazrigos]

That's how you declare a variable in Visual Basic. It is a keyword in that language.

[@joaobatistaful]

Declaration in memory.

[@vin-kingsleyonianwa5483]

Genius

[@saheli86]

Can you give presentation on Variable Type with example

[@mafpin1]

Anyone can help me, how to copy cell a1:c10 to A11, to A21, to A31, to A41 until A91. Thanx alot

[@dilipdelwash6436]

greet .......

[@theknowledgejunction5338]

For loop how it works
ua-cam.com/video/wE5hGXP7hA0/v-deo.html

[@Optionswala3]

Aweosme

[@theknowledgejunction5338]

For loop
ua-cam.com/video/wE5hGXP7hA0/v-deo.html

[@syahir1000]

This guy look like suno nigam

[@bingyan]

The slant is so distracting

[@MrSubhangkar]

Video is not visible. Can you upload new visible video, so that i can see the example of it?

[@caushalaac9282]

hi

[@Marcos.cammndo_20911]

Hindi me sang na

[@sherafgankhan9035]

how to solve this equation type series in excel.if p is any value in milimeter and u's are assumed values 6%=0.06 and so on
p1u1=q1
p1u2+p2u1=q2
p1u3+p2u2+p3u1=q3
p1u4+p2u3+p3u2+p4u1=q4...……………….like this till 70

[@abdullahaleeban6604]

A UD student in CME 281 came here.