Search:

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

Page 1 of 8 1 2 3 4

Search: Search took 0.02 seconds.

  1. Maud, That is the problem, I cannot set it up...

    Maud,
    That is the problem, I cannot set it up the way I want, 2 screens in 1 instance of Excel. When I select "new window", it opens a new window in another instance of Excel.
    Is there a setting...
  2. http://windowssecrets.com/forums/showthread.php/15...

    http://windowssecrets.com/forums/showthread.php/158740-keep-rows-in-view?highlight=skipro
  3. View side by side in Excel 2013 not same as 2010

    In Dec 2013 I requested help with this. I wanted a side by side view so I could scroll up/down on part of a sheet while seeing other rows of that sheet [or other sheets]. I needed independent up/down...
  4. Replies
    12
    Views
    477

    RG, Interesting, did not see that. Maud, ...

    RG,
    Interesting, did not see that.
    Maud,
    That is what I was seeing, but did not know why. I thought it might have created a continual looping and that was why it would not advanced with...
  5. Replies
    12
    Views
    477

    Maudibe, I am trying to understand your code. ...

    Maudibe,
    I am trying to understand your code.
    Please explain the lines:
    (a1).select
    If eliminated the scripts stops at that point. Is this to prevent a loop?
    Thanks.
  6. Replies
    25
    Views
    669

    Maudibe, Thanks. As you say, these things...

    Maudibe,
    Thanks. As you say, these things continually evolve, especially if they are successful. My main sheet got too busy. These changes also helps me understand the code and approach since my...
  7. Replies
    25
    Views
    669

    Maudibe and dguillett, If data is on sheet...

    Maudibe and dguillett,
    If data is on sheet "daily" and I need the return on sheet "mos sum", how do I change the scripts?
  8. Replies
    25
    Views
    669

    When I run your script, it copies the font format...

    When I run your script, it copies the font format in "B". tried it several times, same result. dguillett's script does not do this.
    see attached 1st 3 returns up to line 43
  9. Replies
    25
    Views
    669

    Thanks for help and this info. To help me...

    Thanks for help and this info.
    To help me understand this better, what triggered this clarification? What does this tell me besides the literal statement? Are you saying dguillett's script does it...
  10. Replies
    25
    Views
    669

    maudibe and dguillett Thanks Maudibe's script...

    maudibe and dguillett
    Thanks
    Maudibe's script copies font format from corresponding column B; color, bold, position in cell[center].
    How is this happening? Where in the script does this occur?...
  11. Replies
    25
    Views
    669

    Folks, You are missing my objective. I do not...

    Folks,
    You are missing my objective. I do not want the Min/Max, I want the first and last for each month. Column A is dates and is in order, column B is data/numbers and is NOT in ascending or any...
  12. Replies
    25
    Views
    669

    unclehewie, Thanks. Is there a solution that...

    unclehewie,
    Thanks. Is there a solution that does not involve the extra columns? Can this be done with a single formula?

    dguillett,
    Confused with your reply. Please explain. Thanks.

    Is...
  13. Replies
    25
    Views
    669

    find first and last values with conditions

    Column A is dates in order spanning several years, column B are numbers.
    I need the sum of the last number minus the first number for each month and year.

    I can set the month/year condition with...
  14. 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...
  15. 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...
  16. 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...
  17. 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.
  18. Replies
    1
    Views
    98

    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?
  19. Replies
    2
    Views
    126

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

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

    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
  21. Replies
    8
    Views
    269

    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?
  22. Replies
    8
    Views
    269

    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?
  23. Replies
    8
    Views
    269

    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...
  24. Replies
    8
    Views
    720

    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.....
  25. Replies
    8
    Views
    720

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

    Maud,
    How would I get this to split at column "U"?
Results 1 to 25 of 177
Page 1 of 8 1 2 3 4