• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. L

    Conditionally Copy multiple excel file

    Looking for help I am looking for a macro that will first check that all excel files are there or not & if all files are there then copy all the excel file & create a new folder & name that folder abc & paste all the excel files in it & delete that abc folder (Note there may be 3 or 4 or more...
  2. L

    Looking to make this macro Faster

    Sub STEP14() Dim wb As Workbook Dim ws As Worksheet Set wb = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\HotStocks\1.xls") Set ws = wb.Worksheets.Item(1) With ws .Range(.Cells(1, 11), .Cells(.Rows.Count, 11).End(xlUp)).Copy .Cells(1, 12) End With wb.Save wb.Close End Sub
  3. L

    Vba Code for correction

    If Ws2.Cells(r2, "D") = ">" Then 'calculate the data 1% with column E of AlertCodes.xlsx & add the calculated result with Column E of AlertCodes.xlsx .Cells(i, "K").Value = Ws2.Cells(i, "E").Value - 0.01 * Ws2.Cells(i, "E").Value Else...
  4. L

    Vba Code for correction

    https://excelfox.com/forum/showthread.php/2579-Macro-Correction?p=14571#post14571
  5. L

    Vba Code for correction

    Hi Experts, Sub STEP6() Dim Ws1 As Worksheet, Ws2 As Worksheet Dim Wb1 As Workbook, Wb2 As Workbook Dim r2&, lr&, i& Set Wb1 = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\1.xls") Set Ws1 = Wb1.Worksheets.Item(1) Set Wb2 =...
  6. L

    If a column Has blank cell then put any word

    Thnx Alot BobBridges Sir for helping me in solving this problem Problem Solved
  7. L

    If a column Has blank cell then put any word

    Column J Already has data in it leave the first J1 bcoz it is a headers If column J has a blank cell then put delete word in that blank cell I will run the macro manually Macro will be placed in a macro.xlsm & the file which has data is 1.xls & both files are located in diffrent place so the...
  8. L

    put decimal before second last number by vba in column E

    Is it something u wanted to tell me but u can't say openly then pm me
  9. L

    put decimal before second last number by vba in column E

    Yes I read that hint too.. I will run the macro daily & manually by me U said right So anything if u wanted to say then pm me By the hint given by you I understood only this much only
  10. L

    put decimal before second last number by vba in column E

    Means I understood u told me to provide complete details in the post & I will follow the same from now
  11. L

    put decimal before second last number by vba in column E

    Problem Solved Sub DivideBy100() Dim wbk As Workbook Dim wsh As Worksheet Dim m As Long Dim rng As Range Application.ScreenUpdating = False Set wbk = Workbooks.Open("Alert..xls") ' Add the path yourself Set wsh = wbk.Worksheets(1) m = wsh.Range("E" &...
  12. L

    put decimal before second last number by vba in column E

    Ok Bro Sorry for the same It won't happen Again This point will be added in my future post from now
  13. L

    put decimal before second last number by vba in column E

    Sure from next time I will keep in mind that also & I just copy pasted the question to other forum I have not added any additional information to the question But No Problem From next time I will provide all the info regarding the problems & Sorry for the same This will not be repeated in future
  14. L

    put decimal before second last number by vba in column E

    I have followed the rules Sir I cross posted this question But I shared the link of each other in both the forums Sir Sir I am looking for code that I will run & that thing will happen & with this macro that is not possible So I thought to ask in another forums also So I get the better Result...
  15. L

    put decimal before second last number by vba in column E

    Thnx VletM for ur Great Help & for trying to help me in solving the same & Have a Great Day
  16. L

    put decimal before second last number by vba in column E

    No Problem Sir but this is not solution What i am looking For https://eileenslounge.com/viewtopic.php?f=30&t=34932
  17. L

    put decimal before second last number by vba in column E

    Maro will be placed in macro.xlsm and the file where we will make changes is different Sir
  18. L

    put decimal before second last number by vba in column E

    Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 5 And Len(Target.Value) > 0 Then On Error Resume Next ASE False Target.Value = Target.Value / 100 ASE True End If End Sub Sub ASE(ss) With Application .EnableEvents = ss...
  19. L

    put decimal before second last number by vba in column E

    There is no macro in the file & I mm looking only for Macro VletM Sir So plz help me in solving this probelm Sir
  20. L

    put decimal before second last number by vba in column E

    Hi Maro will be placed in macro.xlsm Put decimal before second last number in column E of alert..xls by vba so the reesult will be in column E is 1410.5 1510 Thnx plz see the uploaded file
  21. L

    Copy and paste

    i am new to vba Marc sir and i already done the same but i was unable to write so plz guide sir
  22. L

    Conditionally dete the row datas

    Sir i am using High end Pc with 16gb ram I think that whatever help everyone is providing i am happy with it they are giving their precious time and help for my problems its a big thing for me i cant say that this is good or bad or plz make better code for me its a help good or bad everything...
  23. L

    Vba code help

    Sub Main2() Dim ws1 As Worksheet, r1 As Range, f1 As Range Dim ws2 As Worksheet, r2 As Range, f2 As Range Dim p As String, r As Range p = ThisWorkbook.Path & "\" 'Path for workbooks to open. 'ws1 and ws2 workbooks are expected to exist and worksheet index of 1 for each...
  24. L

    Conditionally dete the row datas

    Thnx Marc L Sir for giving ur precious time and Great Support to this post Have a Great Day
Back
Top