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..😍😘
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
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
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
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
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?
Dim vCl As Range Dim vRng As Range Set vRng = Range("A1", Range("A1").End(xlDown)) For Each vCl In vRng If vCl.Value < 100 Then vCl.Interior.Color = vbYellow End If Next vCl Ref: uniqueexcelvba.blogspot.com/p/loop.html