Excel VBA - If Else Using For Loop

Excel VBA - If Else Using For Loop
Watch More Videos at:
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

[TutorialsPoint_]

Use coupon "YOUTUBE12" to get ‘’FLAT 12%’’ OFF at Checkout.

[pankajjha]

Thanku so much such aapki bajah se me VBA me Zero se Hero ho gaya..😎😊
Muje aapki video itni pasand aayi ki
Mene Poori 100 Video dekhi 1 day me
Thanku again sir..and love you so much..😍😘

[sabrinabast]

I am struggling and hoping you can assist me. I am trying to loop the VBA code below. I want it to continue till from row 4 to row 4000 (large document).... How can I do that?

Sub RunSUMTotals()
'
' RunSUMTotals Macro
'
' Keyboard Shortcut: Ctrl+Shift+R
'

Range("B4").Select
Selection.End(xlDown).Select
Selection.AutoFill Destination:=Range("B12:E12"), Type:=xlFillDefault
Range("B12:E12").Select
Range("B13").Select
Selection.AutoFill Destination:=Range("B13:E13"), Type:=xlFillDefault
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Selection.AutoFill Destination:=Range("B22:E22"), Type:=xlFillDefault
Range("B22:E22").Select
Range("B23").Select
Selection.AutoFill Destination:=Range("B23:E23"), Type:=xlFillDefault
Range("B23:E23").Select


End Sub

[ksramani]

Loop should not be repetitive on same data transfer to sheet 2, 3, 4 in my own example etc., even in any number of times if run it pl tell me what is the code to insert - only top data to retrive

[jontykmc]

Very well explained...Please do more videos...

[lord]

How to compare a cell in 1st sheet to 3rd sheet using this method

[poojakorde]

Your videos support us for our exam. ....Thank you so much Sir

[LaoderMax]

Sir, help me how to create Input data button example: I want to show data on these cells A1:A50 and have 3 input A B C button.
1. I click on A button will show on A1 cell.
2. I click on B button will show on A2 cell.
3. I also click on C button will show on A3 cell and continue down until end A50
Help me, please. Thanks

[sakshiagarwal]

Why we have added ' Next x' in the last?

[MithileshKumar-vieg]

How can make class and roll no wise search button in excel VBA user form. Please make a video on this Sir.

[khairulaznal]

How can I make it automatic meaning every time I open excel and enter a value it automatically detect and assign the number without the need for me to run VBA code all over again?

[Humayun]

sir what if we have percentage instead of num then will it work

[MrSameershareef]

Have a doubt if we don't know how many students are there ..then which code we can use for that.for pass and fail for many students

[asadost]

Can u teach how to calculate percentage of given amount, like my amount in text box1 is 100 and discount rate in text box 2 is 5%, text box 3 will show the value of 5% & text box 4 will deduct the 5% or value from textbox1. Can u guide and provide the code

[jiyaadnaeem]

Thank you, helped me see where my syntax was off

[SuperStreet]

thank you, very usefull for one of my requirement today.

[alejandroauqui]

thank you very much!, Your videos help me a lot!

[ChachujeeHomeo]

Sir I have an Query Plz help me for my query

[mellowjello]

the confidence in this man is un matched

[Swapnil]

Please create video on dynamic range selection