Search:

Type: Posts; User: alan sh; Keyword(s):

Page 1 of 10 1 2 3 4

Search: Search took 0.01 seconds.

  1. Can I stop notifications from being displayed?

    I have the Windows 10 notification icon in the tray area. I keep trying to set it to "only show notifications" or "hide notifications and icons", but it keeps coming back. Is there a way I can get...
  2. Try entering your password/pin number in notepad...

    Try entering your password/pin number in notepad (where you can see it) - and then cut and paste that into the password prompt.

    Alan
  3. You are all making this very hard. It's easy....

    You are all making this very hard.

    It's easy. Select all the files which have the same year. Right click and select properties. Click on the "Details" tab. Enter the correct year in the "Year"...
  4. You are right - it didn't change. I am...

    You are right - it didn't change.

    I am surprised (and disappointed) that HP decided not to support this in their top end laptop where they "claim" an extended battery life. Maybe it's to stop the...
  5. Thanks. I'll try that. I did ring HP and they...

    Thanks. I'll try that.

    I did ring HP and they said that the DischargeRate was not supported - which struck me as very strange.

    Let's see what a calibration does.


    Alan
  6. WMI Battery status showing discharge rate of large negative number

    Here's a weird one.

    I have two laptops - both running the latest Windows 8.1 (including all updates). On my HP Envy, if I use WMI Explorer to look at the Battery status Discharge Rate, I see a...
  7. Replies
    6
    Views
    277

    I'vw got an HP Spectre 360 with a 2560 x 1440...

    I'vw got an HP Spectre 360 with a 2560 x 1440 display on a 12" screen - so much the same as you. What I've done is gone into Control Panel -> Display and lowered the "Size of all items" down one...
  8. You could add a filter, filter by colour and the...

    You could add a filter, filter by colour and the populate all those that are visible.

    Alan
  9. Where do I find a list of all possible actions for .cell

    I have some simple code:



    Set wldata = Worksheets("Server List")
    line = 1
    lastone = wldata.Cells(Line, 36)


    Now I know if I want the results of the data in cell 1,36, I use
  10. Replies
    18
    Views
    1,155

    Yes, but the event could be him pressing a...

    Yes, but the event could be him pressing a button.

    ALan [Always one for the simple solutions]
  11. Replies
    18
    Views
    1,155

    You are making this very complicated. Why not...

    You are making this very complicated. Why not have a button which, when pressed, will copy the count to another cell. If you don't press the button, the cell doesn't change. Press it when you want...
  12. Ah, that old favourite - "Indirect". many...

    Ah, that old favourite - "Indirect".

    many thanks, I'll give it a whirl.

    Alan
  13. Summing a variable number of rows - how, without a macro?

    As the title says..

    I have a cell with a number in it and, across from that, a variable number of cells in 1 column. I want to sum them, but the number of cells depends on the cell with the number...
  14. And I've found the problem....... A series of...

    And I've found the problem....... A series of coincidences and muddles.

    It appears that Excel 2013 handles which sheet/tab is the active one slightly differently to Excel 2010. When I put in...
  15. OK - Just tried it (I have an excel 2013 machine...

    OK - Just tried it (I have an excel 2013 machine here) and it made no difference - whether I did it from options or from the code.

    Very weird. I need to do more investigation

    Alan
  16. Maud, That's very interesting and something I...

    Maud,

    That's very interesting and something I was leaning to. I didn't know about the code you mentioned but I will try it out when I am back home tomorrow. I've also updated one of my Excel 2013...
  17. David - thanks for that. I will certainly look...

    David - thanks for that. I will certainly look for updates, but I am not sure it's the same problem because it works if I put a break in there.

    I'll keep you all posted

    Alan
  18. I've written some horrible code to get around it...

    I've written some horrible code to get around it - basically each time I write a cell, I check to see if the value should be a number or a date (it fails on both) and then format the cell...
  19. Zeddy, That made no difference. Still the same...

    Zeddy,

    That made no difference. Still the same issue.

    I've tried it on 3 machines with Excel 2013 - fails on all of them - and 2 machines with Excel 2010 - works on all of them

    Sorry

    Alan
  20. Update - it seems to work OK if I use Excel 2010....

    Update - it seems to work OK if I use Excel 2010.

    Wonderful!!! (Not)

    Alan
  21. [solved]EXcel 2013 - Code seems to be bypassed if I don't put a break in

    I have some code as shown below which selects a column and sets the format to 2 decimal places (all the data is numeric). If I don't put in a break at the "columns(I).select" line, the output doesn't...
  22. Its possible. But it works with my desktop device...

    Its possible. But it works with my desktop device through the KVM.

    OK - if no-one knows how to manually modify the screen resolution (I was expecting a registry hack or similar), I'll carry on the...
  23. The monitor will do 1920 x 1200. As I said, when...

    The monitor will do 1920 x 1200. As I said, when I connect directly using DVI, it works fine.

    Yes, there are a few resolutions available in the list, but not that one, when I am going via the KVM...
  24. Both monitors are identical. The native...

    Both monitors are identical. The native resolution of both is 1920 x 1200.
  25. I want them to be the same - the trouble is, one...

    I want them to be the same - the trouble is, one is coming up as 1920 x 1080 when the native resolution for both is 1920 x 1200
Results 1 to 25 of 246
Page 1 of 10 1 2 3 4