Search:

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

Page 1 of 10 1 2 3 4

Search: Search took 0.01 seconds.

  1. 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...
  2. 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
  3. 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...
  4. 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
  5. 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...
  6. 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
  7. 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
  8. [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...
  9. 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...
  10. 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...
  11. Both monitors are identical. The native...

    Both monitors are identical. The native resolution of both is 1920 x 1200.
  12. 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
  13. 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...
  14. 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...
  15. 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...
  16. 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
  17. 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...
  18. 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...
  19. 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...
  20. Replies
    5
    Views
    213

    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
  21. 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...
  22. Yes, I gathered that (later on). Cheers ...

    Yes, I gathered that (later on).

    Cheers

    Alan
  23. 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
  24. 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...
  25. 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
Results 1 to 25 of 233
Page 1 of 10 1 2 3 4