Search results

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

Thanks Hui, 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

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

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

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

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

Thank you very much for your examples. I will study them and hopefully understand the concept. 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...

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

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

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

Thanks Hui,that worked perfect! codedreamer

Yes, that is exactly what I need. For Each ws In ThisWorkbook.Worksheets ws.Name = ws.Range(&#34;a1&#34;).Value Next Thank you for your help codedreamer

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

Hi Luke, I don't know what I did yesterday, I retype the same today and it worked. Thanks

Yes, it is in a for ..next loop. That is exactly what I tried.

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

Thanks a lot Hui, I typed the wrong cell number. It works perfect! Codedreamer

Hi Hui, I tried the code in the example worksheet and it worked perfect, but when I run it in the original it gives me an object define error. The only difference is tha the cell I am referencing is a merge cell. Could this be the cause of it? Thanks, codedreamer

Hi, here is the link I hope I did this right. This is just a piece of the actual workbook https://www.dropbox.com/s/0ds3y8a98vy6tz6/Bake%20Sale.xlsx The diferent values correspond to customer's names, that will change periodically. The names are in a sheet name Purchaselist, then each sheet...

Thank you Hui, I did tried that, but I got an error message. I thought it was because cell a1 contains a link = purchaselist1!e3, so I was trying to get the value that is originaly place in e3. Since it is 20 different values I was trying to use vba to speed the process. Is there a way to get...

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