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

  1. C

    How do I account for empty cells?

    I have several conditionals in a cell is something like this: =IF(AND(A1<2,B2>4),"1") How do I get the result to be an empty cell if either A1 or A2 are blank(no data in them)? I tried isblank, but did not worked for me, I also tried saying A1="", but it did not work either, neither <> worked...
  2. C

    how to keep forms unchanged?

    Hello, I have a form with formulas and vba code. The code is password protected and the document is read only, but when is saved as the cells can be partially modify. what can be done to prevent this from happening? Thank you for your help. Codedreamer
  3. C

    How to merge rows, higlight the content of the merge cells and...

    Thanks Hui, codedreamer
  4. C

    How to merge rows, higlight the content of the merge cells and...

    Hi, I need to merge a block of text(rows and columns), highlight the merge cells and move that to a column on a different spreadsheet in a different book. I have the merge and highlight done using vba, how can I move this data? Thanks, codedreamer
  5. C

    comparing values in two to four coumns

    Thank you so much Sajan. That's what I needed Codedreamer
  6. C

    comparing values in two to four coumns

    https://www.dropbox.com/home/excel?select=numbers.xlsx Hi Hui, Here is the link. I really need to know how many of each kind I have, but thought that if they are colored it would be easier to count. The numbers should be adjacent to each other for example in column ab, cd, so the first set...
  7. C

    comparing values in two to four coumns

    I am trying to compare values in 4 columns. I would like the equal values to be highlited and if the number on the left is les than the number on the right to higlit with another color. I know I can use count if to get the numbers I want, but how can I get them in contiguos cells? thanks for...
  8. C

    Excel 2010 and windows 7 speech recognition

    I wonder if anybody knows where to find the commands to dictate to excel using windows 7 speech recognition. I have search, but all I have found is related to word. Thanks in advance. codedreamer
  9. C

    if then vs select case

    Thank you so much Hui, the way you wrote the if then endif is really nice. Narayank991 the article is very interesting, never thought to go to wikipedia. I think I got it now. Thank you very much to all of you. Codedreamer
  10. C

    if then vs select case

    Thank you very much for your examples. I will study them and hopefully understand the concept. Codedreamer
  11. C

    if then vs select case

    I am trying to understand the relationship between if then else statements and select case. So I tried to convert if then to select case, but I do not know how to do it. This is all I could come up with. Pointing to easy to understand article or a simple explanation would be appreciated...
  12. C

    How can I join 2 statements?

    It works now. I just deleted the phrase and typed it again. Thanks for your help. Codedreamer
  13. C

    How can I join 2 statements?

    Hi Hui, Thank you for your explanation. I did try that way first, but I get a run time error 1004 "application-defined or object defined error". I do not understand what that means. Thank you for your help, Codedreamer
  14. C

    How can I join 2 statements?

    Hello, I have a macro where if one condition is true then two things should happen. I tried to used "and", but it gives me an error message. This is what I have: If ThisWorkbook.Sheets(i).Range(&#34;A1&#34;).Value = 5 Then ThisWorkbook.Sheets(i).Range(&#34;B2&#34;).Value =...
  15. C

    1004 run time error

    Thanks Hui,that worked perfect! codedreamer
See more
Back
Top