Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BJ1106

  1. BJ1106

    How to catch an empty cell which has a formula

    I just tried when you before i saw your post, yes, it works perfectly. thank you very much.
  2. BJ1106

    How to catch an empty cell which has a formula

    *************************** Sub whats_that() MsgBox ActiveCell.Value End Sub *************************** i ran the above code, the message box showing "0".
  3. BJ1106

    How to catch an empty cell which has a formula

    Hi John, I did mention what I am trying to do in my prior post. the exactly formula i am using in a cell C1 is: =IF(AND(ISBLANK(A1),ISBLANK(B1)),"---"),IF(AND(ISNumber(A1), ISBLANK(B1)),"100%",IF(AND(ISNUMB ER(A1),ISNUMBER(B1)),(A1-B1)/B1,""))) since A1, B1 have formula, the ISBLANK...
  4. BJ1106

    How to catch an empty cell which has a formula

    well, Master!B2's formula is =SUM(W6:Y11). the each cell in this range has formula also, for example, W6's formula is "=O22", O22's formula is "SUM(C8:C21)".
  5. BJ1106

    How to catch an empty cell which has a formula

    Here is what I am trying to do: Col A Col B Col C Row1 27 100% Row2 --- Row3 50 20 120% Cells A1, A2, A3, B1, B2, B3 all have fomulas. Situation 1: A1 has value, B1 is empty, C1 shows 100%; Situation 2: A2 is empty, B2 is empty...
  6. BJ1106

    How to catch an empty cell which has a formula

    I tried LEN function. if A1 is empty, Len(A1) returns 1; If A1 has value 1, Len(A1) also returns 1.
  7. BJ1106

    How to catch an empty cell which has a formula

    well, the formula is very complicated. for example, i am checking whether A1 is empty: A1 = C1; C1 = "Sheets!D1" D1 = Sum(P1:Q10)" I am just giving you one example of how the formula looks behind. And I am dealing with many cells like this situation, and each cell somehow link to a cell...
  8. BJ1106

    How to catch an empty cell which has a formula

    Yes. I did try ISBLANK.
  9. BJ1106

    How to catch an empty cell which has a formula

    Hi, How can I catch an empty cell? the cell has a formula which reference to another cell. I tried isblank(A1), didn't work; I tried trim(A1) = "", didn't work; I tried len(A1) = 0 (returend 1), didn't work. Can anyone please help? what i try to accomplish is if A1 is empty, B1 shows "---"...
  10. BJ1106

    Seagate Crystal Reports has encountered a problem...

    Thank you for your reply. I am doing as you suggested. I deleted all the new formula I added to it then added back one at a time then run it, save it. so then i can find out which formula failed on me... :(
  11. BJ1106

    Seagate Crystal Reports has encountered a problem...

    I have created a report. the main report will pass some values to a subreport. the subreport is showing all the details for each record. It worked fine. And i was working on it today. when i tried to refresh data and move page by page, when it reached to page 10, i received the error window...
  12. BJ1106

    Run "Selection.Find.Replacement.ClearFormatting" - VBA

    Well, when to call the macro to replace the words is ondemand by user not me which means they would like to run this macro anytime they want to change the words.
  13. BJ1106

    Run "Selection.Find.Replacement.ClearFormatting" - VBA

    Let me make my question clearly: I am trying to write a macro to replace a word from a template but not in text formields. For example, I have a checkbox, and put a description next to this check box as "Exceeds Expectations". now I want to run the macro to replace "Exceeds Expectations" with...
  14. BJ1106

    Run "Selection.Find.Replacement.ClearFormatting" - VBA

    Gerry, I tired. But if there are "Exceeds Expectations" in text formfields which is user entered and suppose not be replaced was replaced with "Excellent" also.
  15. BJ1106

    Run "Selection.Find.Replacement.ClearFormatting" - VBA

    Hi, I am using a macro to search one word and replace it using a different one. For example: Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "Exceeds Expectations" '20 .Replacement.Text =...
See more

Part and Inventory Search

Back
Top