Recent content by BJ1106

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

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

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

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

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

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

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

Yes. I did try ISBLANK.

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

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

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

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.

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

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.

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