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

Recent content by mandarp22

  1. M

    Text formatting in a string

    Hi All I am trying to format text in a string. I receive this worksheet from third party and I have to print visiting cards using this information. Data received contains lot of formatting errors like upper and lower case, double space between words, which I cleared the most of it with the help...
  2. M

    Need VBA code to select Range with Real values only

    can anybody pls help
  3. M

    Need VBA code to select Range with Real values only

    Hi Chirayu thanks for the help I found this code below that works great for me. Only problem is I want to run this code on Sheet2 from commend button on Sheet1….. Private Sub CommandButton1_Click() Dim rng1 As Range Dim rng2 As Range Dim rng3 As Range Set rng1 = Cells.Find("*"...
  4. M

    Need VBA code to select Range with Real values only

    sample file uploaded
  5. M

    Need VBA code to select Range with Real values only

    Hi All I have data in “column D” in my work sheet, which is derived by formula and now I want to select a range of cells with VBA code in “column D” after the cell “D1” of the worksheet till the last row with the Real Value ignoring the cells with formula result “Blank” below the last Real value...
  6. M

    please guide to get a shorter IF function

    also need to apply same formula in each cell of "Sheet2 Column BB"
  7. M

    please guide to get a shorter IF function

    Yes I did press ENTER key after DELETE..
  8. M

    please guide to get a shorter IF function

    Hi...... no I just downloaded the file the put name (Mandar) in "sheet1 D4" and it worked then I delete name (Mandar) in "sheet1 D4" with delete key on keyboard but nothing happens..
  9. M

    please guide to get a shorter IF function

    Hi Vletm.... yes something like this.... but in this when I put filter it works and produce the statement i.e. dates between and name.. but when I remove filter (name) nothing happens.. Regards Mandar
  10. M

    please guide to get a shorter IF function

    Thanks Narayan for the help..
  11. M

    please guide to get a shorter IF function

    Hi Narayan thanks for throwing some light.... But unfortunately I am not good in vba... Can I get some solution??.. Mandar
  12. M

    please guide to get a shorter IF function

    Hi Narayan and Hui Sorry to confuse you, here is the whole concept in sample file. In this file I have Invoice data stored in sheet2 and in sheet1 I want to generate Invoice Statement based on filters (basic 5 filters) and we can make 23 combinations of these filters together to generate...
  13. M

    please guide to get a shorter IF function

    Hi All I have 23 combinations from column A to E and in column G…. I want to give each combination unique number. At present I am doing it with IF function and it's working fine as I am using office 2007 but it is too long and any small mistake can be painful. Is there any shorter way to do it...
  14. M

    need help to get user form in fullscreen

    Belleke's solution works great for me Thank you
  15. M

    need help to get user form in fullscreen

    Hi All I have a Excel file with open event which hides the application and show only user form but the user form is small in size. I want the form to open in Maximized State. any help? Regards Mandar
Back
Top