Search:

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

Page 1 of 7 1 2 3 4

Search: Search took 0.02 seconds.

  1. RG, My Uninstall button was greyed out because...

    RG,
    My Uninstall button was greyed out because I did not have "Client for MS Networks " highlighted. Again, everything works..
    My OS just does not recognize this as Wi-Fi, to SOME extent. Enough...
  2. Sudo, Your screens are as they should be but...

    Sudo,
    Your screens are as they should be but you can see from my screenshots I do not get the "wireless" button or "security" tab. That is my question. Yes, I get the "connect/disconnect" and I do...
  3. Sudo, When I click on my wireless connection,...

    Sudo,
    When I click on my wireless connection, as you suggested, the screen that comes up is the "status" screen with "properties" button. A normal "status" screen has a "wireless properties" button...
  4. no "wireless" button in Wi-Fi status screen

    Win 8.1
    Wi-Fi works fine, but there is no "wireless" button in Wi-Fi status screen. Without this I cannot save password.

    see attached screen shot.
  5. Replies
    1
    Views
    51

    replace "0" with text

    Formula:
    =(LOOKUP(9E+307,IF(F:F>0,F:F)))-MAX(F:F)

    If the value equals "0", I want to replace the "0" with a text "xx" in the cell, that is, show "xx".
    How do I add this to the formula?
  6. Replies
    2
    Views
    65

    RG, Just what I needed but could not quite get...

    RG,
    Just what I needed but could not quite get correct. Thanks.
  7. Replies
    2
    Views
    65

    Formula returns Fx, I want Ax

    A = Dates
    F = numbers
    Formula = Max(F:F)
    I want to return the corresponding "A" or date of the max number.

    EX)
    A1= 1/1/2014 F1= 10
    A2= 1/7/2014 F2= 50
    A3= 1/20/2014 F3= 16
  8. Replies
    8
    Views
    138

    Thanks everyone for your input but I did not...

    Thanks everyone for your input but I did not state my question clearly. I am trying to replace the "default" grid which apparently is not an option in "format/borders". Is this possible?
  9. Replies
    8
    Views
    138

    Thanks RG but this did not work. The reason I...

    Thanks RG but this did not work. The reason I lost the grids is that I color filled the area and that removes the grids. To re-ask the question, how do I color fill and not lose the grids?
  10. Replies
    8
    Views
    138

    replace default grids

    I have a section that lost the standard grids lines. If I add lines using "format/borders", the grid lines are different than the default grid lines. How can I replace these grids without deleting...
  11. Replies
    8
    Views
    654

    Maud, I had tried that before and no number...

    Maud,
    I had tried that before and no number change had any effect. Still split at "K". Got idea to rerun macro manually and that did it. Previously it was just loading the saved file.
    Duh.....
  12. Replies
    8
    Views
    654

    Maud, How would I get this to split at column...

    Maud,
    How would I get this to split at column "U"?
  13. Replies
    29
    Views
    2,137

    Steve, To clarify, the return is not predictable...

    Steve,
    To clarify, the return is not predictable and may be either a number or a text. Both the result's numbers or texts will vary, depending on the conditions. The value of the cell with the...
  14. Replies
    29
    Views
    2,137

    What can I do if the call may return a number or...

    What can I do if the call may return a number or a string?
  15. Replies
    29
    Views
    2,137

    Steve, It seems the "+" is the basic arithmetic...

    Steve,
    It seems the "+" is the basic arithmetic function. Can I add a non-arithmetic function after GetComment so it will run and give a return? Such as an IF or VLookup function?

    =GetComment...
  16. Replies
    29
    Views
    2,137

    Steve, Ah, ha! That seems to be it. Your...

    Steve,
    Ah, ha!
    That seems to be it. Your solution is also where my mind was going so I could cover all circumstances, essentially a 2 step process.
    1-Get Comment
    2-get value
    I was trying ...
  17. Replies
    29
    Views
    2,137

    Steve, I have been unavailable to follow-up. ...

    Steve,
    I have been unavailable to follow-up.

    The content of the destination cell varies too much to have a script/macro/UDF specific for each, that is why I have not/cannot answer your request...
  18. Replies
    4
    Views
    742

    Maud, Good job, does what I need. Thank you.

    Maud,
    Good job, does what I need. Thank you.
  19. Replies
    29
    Views
    2,137

    Steve, Thanks, but not what I need....

    Steve,
    Thanks, but not what I need.
    A1[worksheet1] has a value of 5 and a comment. - I refer to this cell as the source cell.
    B2[worksheet2] has a value of 9[this may be a simple value or an...
  20. Replies
    29
    Views
    2,137

    Steve, Thank you for your continuing help. ...

    Steve,
    Thank you for your continuing help.

    My original request was to copy cell [value] and comments.

    But I have 2 worksheets that have a few cells that are related but with different...
  21. Replies
    4
    Views
    742

    Steve, Thanks, but I need it to automatically...

    Steve,
    Thanks, but I need it to automatically come across when I reference a cell from one worksheet to another, like you helped me with including comments when referencing cells across worksheets....
  22. Replies
    4
    Views
    742

    include formatting when referencing cell.

    How can I include a cells formatting when referencing it.
    B1 to equal or reference A1; B1 will have same formatting as A1. Mostly across worksheets.

    I would like it to include Font...
  23. Replies
    29
    Views
    2,137

    How can I copy the comment without the contents?

    How can I copy the comment without the contents?
  24. Replies
    29
    Views
    2,137

    Steve, Thanks.

    Steve,
    Thanks.
  25. Replies
    29
    Views
    2,137

    Steve, When I use your function but do not have...

    Steve,
    When I use your function but do not have a comment in 1st cell, I get #Value!. Add a comment, OK. Delete comment get #Value! but does not remove the comment in cell 2.
Results 1 to 25 of 164
Page 1 of 7 1 2 3 4