Search:

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

Page 1 of 9 1 2 3 4

Search: Search took 0.02 seconds.

  1. 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...
  2. 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...
  3. Both monitors are identical. The native...

    Both monitors are identical. The native resolution of both is 1920 x 1200.
  4. 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
  5. Yes and it does detect a display but does not...

    Yes and it does detect a display but does not display the correct resolutions.

    It gets weirder (I haven't mentioned this before). I actually have 2 24" displays - both identical. When they are...
  6. I have tried different cables. Not sure if I've...

    I have tried different cables. Not sure if I've tried different ports, but as it works on laptop boot (did I say its a laptop? ) I wouldn't expect that to make a difference.

    As to selecting the...
  7. Cheers - but that is not my issue. The PC WILL do...

    Cheers - but that is not my issue. The PC WILL do 1920 x 1200 - it's just not playing ball when I go through my KVM.

    So, back to my original question - can I manually set the resolution of a...
  8. Yes, I have loaded the HP drivers for the monitor...

    Yes, I have loaded the HP drivers for the monitor and it makes no difference.

    Alan
  9. The other thing to mention is that when the...

    The other thing to mention is that when the Windows 7 PC starts up, the boot screen will show on the monitor if using VGA directly - it's only when Windows starts up that it all goes black again. I...
  10. The KVM works fine with my other system and two...

    The KVM works fine with my other system and two others that I have connected (it's a 4 way KVM). It's just this one Windows 7 box (which has a specific HP derived build on it) which is causing...
  11. How can I manually set the display resolution?

    I have two computers and 1 monitor and a KVM switch.

    One of the computers will not recognise that there is a display (HP 24" monitor) over the VGA port via the KVM switch. There seems to be a line...
  12. Replies
    5
    Views
    140

    Which also shows you which forum is best. Eileens...

    Which also shows you which forum is best. Eileens Lounge said it couldn't be done - this one provides the answer as to how it CAN be done.

    I know where I'm staying :)

    Alan
  13. Thanks all. Very interesting stuff. I modified...

    Thanks all. Very interesting stuff.

    I modified RG's original to give me back the row and column number and it works great.

    However, don't pass a range that is all the columns or it will loop...
  14. Yes, I gathered that (later on). Cheers ...

    Yes, I gathered that (later on).

    Cheers

    Alan
  15. Thanks both - I like both answers but I have no...

    Thanks both - I like both answers but I have no idea why SUMPRODUCT works. Also, Maud, your text doesn't quite match the formula - the value is in B1, but your formula has $A$1 in it.

    Alan
  16. Is there a version of "MATCH" that works with multiple columns?

    Hello experts,

    I have a 2 dimensional array of bits of text. I want to find the row and column of one of those bits of text.

    I thought MATCH would do it - but that only works if you have a...
  17. Humm - I tried that code and it didn't like "cn"....

    Humm - I tried that code and it didn't like "cn". I just did a cut and paste (replacing semi colons with commas)

    Alan
  18. Cheers - will do

    Cheers - will do
  19. And here is the final code

    Thanks to RG for his input. If anyone wants to use this, feel free. If you wish to modify it (maybe add hours, mins seconds etc) help yourself.

    The code will check if a directory called "backup"...
  20. Cheers RG - your code works fine. Alan

    Cheers RG - your code works fine.


    Alan
  21. Thanks RG. I did find that article and applied...

    Thanks RG. I did find that article and applied it.

    My code looks like this, but for some reason, it posts the message box twice - no idea why though - any clues?:

    It also asks me if I want to...
  22. Change the default behaviour of the "save" button?

    I have a spreasdsheet - when a user clicks on "Save" (or does it from the menu), I want my macro to be run instead (it will add the current date/time to the end of the filename to force a sort of...
  23. I think a right click context menu is what I am...

    I think a right click context menu is what I am looking for too. But not from within Excel. If I have 3 excel workbooks and I want to open them in new instances of Excel, is there a way to add this...
  24. I use ...

    I use

    =if(isna(vlookup(....)),"",vlookup(....))


    Alan
  25. Thanks. I like that idea as well. I'll play...

    Thanks. I like that idea as well. I'll play tomorrow.

    Alan
Results 1 to 25 of 225
Page 1 of 9 1 2 3 4