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...
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
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
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...
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
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...
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("A1").Value = 5 Then
ThisWorkbook.Sheets(i).Range("B2").Value =...
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...
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...
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...
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.