Search:

Type: Posts; User: skipro; Keyword(s):

Page 1 of 9 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    5
    Views
    580

    The problem emails are HTML. Default printer is...

    The problem emails are HTML.
    Default printer is same as before, a HP 870Cxi printer.
  2. Replies
    5
    Views
    580

    Outlook 2016 word wrap issue

    Win 10 - Office 2016
    Recently some emails in the reading pane extend well past the normal page boundaries requiring extensive horizontal scrolling. Yesterday the issue seemed to disappeared, today...
  3. Replies
    2
    Views
    232

    macro to refresh values

    I need a macro that will refresh the values using webservice in Excel 2013. I think ctrl/alt/F9 does it but I need a macro for this. I see an what appears to be an update when I manually enter...
  4. zeddy, All looks good now, but 1 thing comes to...

    zeddy,
    All looks good now, but 1 thing comes to mind. It would be very helpful if I can override the DIV/0 error in F when C=0.
    F=(C/D)*G
    I still want the error to return a string as is...
  5. zeddy, In: zFormula =...

    zeddy,
    In:
    zFormula = "=SUMIF(M:M,TRIM(LEFT(A" And zRow & ",2)),N:N)"
    Did you mean the "And" or did you want "&"?

    I originally saw the "And" and wondered why but assumed you had a good...
  6. zeddy, I have spent a lot of time trying to...

    zeddy,
    I have spent a lot of time trying to modify your suggestions to work with my sheet. Finally got all to function as you and I intended.
    At this point only 1 problem has arisen.

    Formula...
  7. zeddy, Yes, in the "real world", I do have C &...

    zeddy,
    Yes, in the "real world", I do have C & D locked.
    Can this be done using your script so C & D can change through the changing of M & N [SUMIF], but not by over-writing the cells in C & D? I...
  8. Replies
    8
    Views
    541

    zeddy, Appears to work as needed. After maud's...

    zeddy,
    Appears to work as needed.
    After maud's last revision, I thought that an automatic delete of N with delete of M was better than a text, which eventually needed to be deleted or overwritten....
  9. zeddy, Too good to be true. Found a problem....

    zeddy,
    Too good to be true. Found a problem.
    You have F change with change in C including a text return for a div/0 error, as requested. Works fine as is. But in my real sheet, C is a SUMIF from...
  10. Replies
    8
    Views
    541

    Maud, Thank you, works fine. I see you added...

    Maud,
    Thank you, works fine.
    I see you added to original script which I received via email. This addition corrects my 1st issue.
    But when I add a value to M then delete it, the 2nd part of the...
  11. Replies
    8
    Views
    541

    Allow N only if M has value

    How would I script to allow value to be entered in N only if corresponding M has a value, otherwise N would return text, "need M". This text would appear only if I had tried to enter a value in N...
  12. zeddy, Double thanks. You are a true gentleman....

    zeddy,
    Double thanks. You are a true gentleman. I know you put a lot of time and effort into this. Greatly appreciated. This now has essentially all the functions I need. Unfortunately it is an...
  13. zeddy, All the potential possibilities or rules...

    zeddy,
    All the potential possibilities or rules are numerous, so let me limit them to the probable.
    "C" will never be all "0"s. Usually none and a maximum of only a few out of about 12+.
    V.4 &...
  14. Zeddy, How do I add your last error script ...

    Zeddy,
    How do I add your last error script

    For Each c In Cells.SpecialCells(xlCellTypeFormulas, 16)
    If c.Value = CVErr(xlErrDiv0) Then
    c.Value = "no entry"
    End If
    Next

    into your V.4?
  15. zeddy, You are welcome. Do not all of your...

    zeddy,
    You are welcome.
    Do not all of your samples deal with that "swap" by replacing the formula or using the script so the override did not interfere?
    My thought was to add this script only...
  16. Zeddy, Thanks for a solution to the div/0 error...

    Zeddy,
    Thanks for a solution to the div/0 error return, but my "retentive side" has me thinking about and researching this.

    Is it possible to incorporate the following code, or a variation, to...
  17. zeddy. Again, thanks, especially for...

    zeddy.
    Again, thanks, especially for explanations so I can decipher and learn.
    I noticed you changed your approach in v.4 in that you replaced the formula in "F" in v.4 when it was overwritten,...
  18. zeddy, You were correct in your second reply...

    zeddy,
    You were correct in your second reply that the second sample [rz1-SKIPRO-sample-2.xlsm] you presented more closely addressed my needs. I did notice, appreciate and use your second sample and...
  19. zeddy, Thanks, works as asked, but can you add...

    zeddy,
    Thanks, works as asked, but can you add these additional functions to accept a changing A1, as A1 is a moving target:
    1) Automatically recalculates C & D with changing A1.
    2) If A1=0, an...
  20. need schizophrenic formula [work both directions]

    I have 2 columns C & D that are related thru a formula:
    C = A1 times D, where D is the variable and is entered to determine C
    If D[2] = 30%, then C[2] = $30 and if D[3] = 60%, then C[3] = $60....
  21. Replies
    10
    Views
    744

    Maud and zeddy, Thanks. This is like dueling...

    Maud and zeddy,
    Thanks. This is like dueling scripts [as in dueling banjos].

    One last question about the original file which I had attached and which I have again attached for convenience. In...
  22. Replies
    15
    Views
    755

    Maud, Thanks. I would like it case insensitive....

    Maud,
    Thanks.
    I would like it case insensitive.
    Are you aware that if an invaild entry is placed in A your message appears and if oked, or if an entry in A is deleted, the cell goes blank. Then if...
  23. Replies
    15
    Views
    755

    Zeddy, Column A works fine, but column B does...

    Zeddy,
    Column A works fine, but column B does not update D-I unless I update/refresh col A. Can this extra step be eliminated so if I change value in col B it updates D-I spontaneously? It appears...
  24. Replies
    10
    Views
    744

    dropbox list limitations, work around

    I have become aware of the 8 row limits [without scrolling] in a dropbox list. Apparently a combobox approach overcomes this limitation.
    I have an example that works but I need help to modify it.
    ...
  25. Replies
    15
    Views
    755

    Maud, Again thank you. Using your last...

    Maud,
    Again thank you.

    Using your last revised sample, if I change a value in "A", it adds "B" in "D-I" appropriately, great. But it leaves the old value in "D-I", not so great. I do not know...
Results 1 to 25 of 208
Page 1 of 9 1 2 3 4