• 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. Niraj Baraili

    VBA Overflow Error

    Thanks p45cal for pointing this out.
  2. Niraj Baraili

    VBA Overflow Error

    Thank you Narayan. Code is running fine now.
  3. Niraj Baraili

    VBA Overflow Error

    Basically this file is generated after applying SubTotal function. All i need to do is to update the formula in Eff Growth and Full Growth column as (value1+value2)/value3 and (value1+value2)/value4 where there are 'Total' keywords in the column Team (A) and Level (Status).
  4. Niraj Baraili

    VBA Overflow Error

    Any feedback will be much appreciated why i am getting Overflow Error in below code: Dim SrchRng2 As Range, SrchRng1 As Range, cel As Range, cel1 As Range Dim i As Long Dim j As Long lastrow1 = wkb2.Sheets("Summary").Cells(Rows.Count, "OE").End(xlUp).Row Set...
  5. Niraj Baraili

    Deleting Duplicate rows

    I found my solution here. Very informative. https://usefulgyaan.wordpress.com/2013/06/12/vba-trick-of-the-week-slicing-an-array-without-loop-application-index/
  6. Niraj Baraili

    Deleting Duplicate rows

    Hi Experts, I found a code in below link for deleting duplicate rows using dictionary method. But i am not able correlate these lines - "Application.Index(sn, j, 0)" and "Application.Index(.items, 0, 0) " . Hope someone will put some light on it...
  7. Niraj Baraili

    VBA Copy Paste not working

    Thank you very much for the insights. After modification as per your advice, it's perfectly giving me the desired result.
  8. Niraj Baraili

    VBA Copy Paste not working

    Hi Expert, Just wondering what is the problem with this code ? As i have a workbook with sheets name 1, 2, 3, 4, 5 and also i have a target workbook with the same sheets name. All i am doing is copying data from sheets (1,2,3...) and pasting it to corresponding sheets in target workbook. But the...
  9. Niraj Baraili

    Removing Duplicate Values-Runtime error 450

    Hi Chihiro, Thanks for your reply. After lots of googling, found a solution. Just changed this line from Application.Index(.Item, 0, 0) to Application.Index(.Items, 0, 0) and it's working fine. Thanks again for pointing this out.
  10. Niraj Baraili

    Removing Duplicate Values-Runtime error 450

    Hi Experts, Could you please look into this code why i am getting Runtime error: 450. wrong number of arguments or invalid property assignment. Sub Test() sn = Sheets("sheet1").Cells(1).CurrentRegion With CreateObject("Scripting.Dictionary") For j = 1 To UBound(sn)...
  11. Niraj Baraili

    VBA code loop through files in a folder based on cell ranges

    Hello Yasser, Sorry for the late reply. Though the above code serve my purpose, i am bit confussed on the line For Each e In Array("*.xlsm", "*.xlsx") Could you please put some light on it ?
  12. Niraj Baraili

    VBA code loop through files in a folder based on cell ranges

    Sample file is attached.
  13. Niraj Baraili

    VBA code loop through files in a folder based on cell ranges

    Hi Experts, I have a cell ranges(A2:A6) as department as below. Department WFM WFA Finance Accounts HR And with the above department name, i have files in a specific folder. Is it possible to loop through each files based on the cell ranges ? Googled a lot but no luck. Hope someone will be...
  14. Niraj Baraili

    Master workbook

    Can you at least share some dummy data for input and how your output look like ?
  15. Niraj Baraili

    Changing datatype in PowerPivot column

    Hello Experts, Is there any way we can change the data type in power pivot column ? I have been trying to change the data type from text to decimals, but it's throwing up 'Type Mismatch' error. Any help on this much appreciated.
  16. Niraj Baraili

    Nested VBA If...End if not working

    Sub check() Dim j As Integer a = Sheet2.Range("a2").CurrentRegion.Rows.Count For j = 2 To a Step 1 If (Sheet4.Cells(4, 15) = Sheet3.Cells(j, 53)) = True Then If (Sheet4.Cells(4, 16) = Sheet3.Cells(j, 52)) = True Then Sheet3.Cells(j, 53) = Sheet4.Cells(4, 20) Sheet3.Cells(j, 40) =...
  17. Niraj Baraili

    Excel Formula to give output in symbols

    Hello Sir, Thank you very much. Now it looks like so simple.
  18. Niraj Baraili

    Excel Formula to give output in symbols

    Hi Experts, Need your help on this... I am trying to build a traffic light chart for which i have downloaded a sample file from Internet. But i am not able to understand how the excel formula is giving output in symbols ? For example, in my case it is 'black dot'. Also, when press 'F2' in the...
  19. Niraj Baraili

    Saving a copy of macro file with no macro(.xlsx format) and do some calculation on saved file

    Hi Ratan, Thanks for the reply. I will try to implement this and any challenges let u know.
  20. Niraj Baraili

    Saving a copy of macro file with no macro(.xlsx format) and do some calculation on saved file

    Hello Folks, Returned back after a long time with a question. I have a macro file called Test.xlsm with sheets Summary, 1, 3. Now, i need to save a copy of Test.xlsm (without macro i.e.,Test.xlsx) and remove all the formulas from all the sheets and delete sheets 1 and 2. Googled for help but...
  21. Niraj Baraili

    Hacking password protected workbook by VBA Codes

    Hi Chirayu, Thank you very much for the reply. I just check brute force software, but confused which application to download ? If you could send me the link it will be great help.
  22. Niraj Baraili

    Remove password

    Hi Luke, Any luck on cracking a excel workbook password which is locked for viewing.
  23. Niraj Baraili

    Hacking password protected workbook by VBA Codes

    Hi Expert, Can we unlock excel workbook which locked for viewing with VBA Codes ? If so, can we have the sample code. Thanks in advance
  24. Niraj Baraili

    Sending Birthday Emails in outlook through VBA

    Thanks for the link Luke. I will check the same.
  25. Niraj Baraili

    Sending Birthday Emails in outlook through VBA

    Hi Experts, Need your help on this. I have a list of emails with date of birth in excel. Also, I have numbers of birthday images saved in a folder. I have to check all the birthday date and match with todays' date and if it is matching then one email has to be shoot to matching id putting rest...
Back
Top