• 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. D

    Problem to print sheet names and convert names as links to those sheets

    Hi Hui, Thanks a lot for the link, it helped me a lot. DJ
  2. D

    Problem to print sheet names and convert names as links to those sheets

    Hi All, Kindly help me with the problem. I am required to print names of all the sheets in a workbook and make these names as Hyperlink to respective worksheets. I am able to print sheet names but don't know how to convert them as hyperlink. Thanks, DJ
  3. D

    How to remove unwanted files?

    Hi Narayan/Bobhc, Thank you for the help. However, as Bobhc said that there will be some difficulty in running many parts of excel, kindly explain what kind of difficulty. I just don't want to see these files in my code window. This is because, whenever I close the excel window it ask 4...
  4. D

    How to remove unwanted files?

    Hi All, Every timne when I open a new workbook, there are 4 files that open and I want to disable them. Those files are (ATPVBAEN.XLAM, EUROTOOL.XLAM, SOLVER.XLAM & FUNCRES.XLAM). I have checked the XLStartup path and only Personal.xlsb is there. Plz help to remove unwanted files...
  5. D

    Inserting a blank row after every alternate item of a list

    Hi All, Thank you so much for the help. DJ :)
  6. D

    Inserting a blank row after every alternate item of a list

    Hi, I need help with a problem. Please help. I have a list in a column. Lets say Sheet1 has a list of names from A1:A50 and I need to insert a blank row after every item of the list. I tried to select every alternate row and insert new row but it inserts a row afer every 2nd item which is...
  7. D

    Invisible character

    Hi Debraj/Faseeh, Thank you so much for the link and formula, it worked perfect. I am very grateful to you as you helped me to save many hours' effort. Thanks, DJ
  8. D

    PivotTable data range

    Hi Faseeh, Thank you so much for valuable suggestion. It worked fine. Thanks, DJ
  9. D

    Invisible character

    Hi Faseeh, As I wrote in my previous post, the spaces I am refering to are not spaces but special charaters. Also, these are not trailing spaces but between the fist name and last name so Trim() will not work. Thanks, DJ
  10. D

    PivotTable data range

    Hi, I have created a pivot table based on some data. The problem is that every time I update data, I am required to delete the entire data (Actually not simple delete but need to remove entire rows which have data)first and then paste the new data then I refresh the pivot. Now problem comes...
  11. D

    Invisible character

    Hi, I received some data from our business partner which has some employee names and their details. Employee's First name and last name should be seperated by a single space only. However, there are many names which seems have two or more spaces. I checked that actually there is single space...
  12. D

    Custom formatting

    Hi, In reference to the technique mentioned at link: http://chandoo.org/wp/2012/05/07/displaying-text-values-in-pivot-tables-without-vba , I want to know if this technique can be used to display a different text in place of the actual text. I tried but it didn't work. Please suggest if any...
  13. D

    Data Validation

    Thank you so much Narayan. I will check the file once I am at home.
  14. D

    Data Validation

    Hi bobhc, Thanks for the help, however, whether I have applied validation or not for a range, I am getting error in both the cases. I would request you to please provide a workbook with the above macro. Thanks, DJ
  15. D

    Data Validation

    I have applied a data validation in a cell so that user can select values from a list only. However, if user copies any other value different than the list values and paste on the cell having data validation it(cell) accepts this new value. I actually want to restrict user so that he/she is...
  16. D

    DisplayGridlines property

    Hi SirJB7, So every time when I need display or remove gridlines of a worksheet, in my code I need to first activate it? Thanks and regards, DJ
  17. D

    DisplayGridlines property

    Hi, I have a query regarding a VBA code that is ActiveWindow.DisplayGridlines = True/False. Why do I need to refer to the active window in the above mentioned code line? If I give a reference to a worksheet that is not active it doesn't work e.g. if write...
  18. D

    Second version of Index Function

    Hi Debraj, Thanks a lot for your time and help. I will check the link later as in office, I am unable to open it. Thanks, DJ
  19. D

    Second version of Index Function

    Hi bobhc, Sorry but given link is not helpful as it explains the first version of Index function. I need help on the second version of Index function which has syntex like '=INDEX(reference,row_num,column_num,area_num) Thanks, DJ
  20. D

    VBA

    Hi Jayadev, When you already have "Jay" in a sheet, then why do you want to extract it from another string. Also, are you following any set pattern in the second sheet i.e. in strings like "jfjhljafvl11/2/12Jay-ext kjdhj" is there any common property?
  21. D

    Second version of Index Function

    Hi xld, Thank you so much for quick reply, however, I have already refered to excel help and didn't find it too helpful. I am unable to explain but I am unable to use it in any of my reports but I think this will be good to learn this function. Hence I need some more examples and situations...
  22. D

    Second version of Index Function

    Hi All, I am using this site since I joined my previous company's MIS department after my promotion and have learnt many functions and techniques. Your website is amezing and I suggest everyone to refer to this website. I learnt Index function from this website, however, I am aware with...
  23. D

    Macro error

    Hi Hui, Plzzzz... help me understand the mistake I did. In my code I was asking code to start again from the beginning to take input again (incase entered no string) and as per your suggestion I am asking code to take the input again. The problem is I am unable to see any much difference so...
  24. D

    Macro error

    Hi Hui, Thank you very much. I worked now. Plz help me understand the mistake I did. As I told in my first post that I am a beginner so I do not want to repeat this error. Thanks, DJ
  25. D

    Macro error

    Hi, In addition to the first post, I know that my code has got stuck in a loop and I can get rid of it by using "Exit Sub" but I don't want to exit from code, I want that if I don't enter a name, it just keep asking me until I enter a name. Thanks, DJ
Back
Top