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

    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
  4. 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...
  5. 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
  6. 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...
  7. 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 =...
  8. C

    1004 run time error

    Hello, I have a macro that changes the tab name of every worksheet in the workbook. It does work as long as all the worksheets in the workbook have data in them, but ocasionally, I will not be using all the worksheets. That is when I get a "run time error 1004" Application-define or object...
  9. C

    macro does not work after renaming workbook

    I have two workbooks, one name BakeSale and one name Receipt. The macro is supose to transfer information from Bake Sale to receipt, but after the workbook is rename it does not work anymore. This is what I have: 'Workbooks("BakeSale.xlsm").Sheets(i).Range("A1").Value...
  10. C

    how to rename a tab using a reference cell?

    Hello, I have a workbook with 20 tabs that need to be rename according to the contents of cell a1. The problem I face is that cell a1 gets its information from another worksheet. I know I can use the indirect function, but I really do not know how. Sub RenameTab() For Each ws In...
  11. C

    Hi

    Hello, I am Ana from USA. I found Chandoo not too long ago, and I love it. I have recomended this website to all my friends. I am looking forward to become awesome in excel.
Back
Top