Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Deniall

    What has happened here to Tek-Tips??

    For those of us who are not up with the lingo, what is a "breadcrumb" when it is at home?
  2. Deniall

    What has happened here to Tek-Tips??

    Thanks, Combo, for the suggestion about using the NOVA style. It removes the problem I had with invisible highlighting when I am composing a reply. Back in the good old days I used to make a lot of use of non-breaking spaces, generated with the code string [ ], mainly (but not only) as an...
  3. Deniall

    What has happened here to Tek-Tips??

    I am in total agreement with all the above. Why was this done without any warning, and without providing registered users (ie contributors) with some sort of description of how to replicate the behaviours and nomenclature we were taking advantage of on the old site? I have wasted several hours...
  4. Deniall

    Not able to log into my previous account, and there's no "Forget Password"

    On my computer at least, the entire site seemed to suddenly change its appearance, its structure and its underlying philosophy three or four days ago. If there was any advance warning that this was going to happen, I missed it. I used to get a start-up screen that simply showed me a summary of...
  5. Deniall

    Count range overlap cells

    I am not aware of how you might do this entirely in the Excel environment, but in the VBA environment you can use the Intersect method. Intersect(Range("a1:d4"),Range("c3:g7")).Address returns $C$3:$D$4 Intersect(Range("a1:d4"),Range("e5:g7")).Address has a null return, meaning that the...
  6. Deniall

    Remove recently used symbol

    I am using Windows-10, and that Alt-key plus numeric keyboard caper seems to work with any program that is expecting keyboard input. [ ]————————————————————————————————— Engineering mathematician/analyst.[ ] See my profile for more details.
  7. Deniall

    Remove recently used symbol

    Another way to get an en-dash is to hold down the Alt key while typing 0150 on the numeric key pad.[ ] To get his big brother the em-dash, it's Alt-0151.[ ] I use both these symbols sufficiently often that it is worth my while to have memorized them...
  8. Deniall

    Where to post Q about Microsoft Powertoys App? Solved

    I have successfully used AutoHotKey for this purpose (shortcuts for text substitution).[ ] When I needed some help with it I posted on this site's "Microsoft:[ ]Windows" forum. [ ]————————————————————————————————— Engineering mathematician/analyst.[ ] See my profile for...
  9. Deniall

    AutoHotKey for a very simple task

    Thanks.[ ] It has (further) helped me, and has become my preferred approach. [ ]————————————————————————————————— Engineering mathematician/analyst.[ ] See my profile for more details.
  10. Deniall

    Lost edited data in Excel File

    If I am working on a complicated spreadsheet for an extended period of time I initiate my own frequent backups in addition to whatever AutoSave might do.[ ] I give these backups different names every time:[ ] MyWorkbook01.xls, MyWorbook02.xls, MyWorkbook03.xls, and so on.[ ] On...
  11. Deniall

    AutoHotKey for a very simple task

    Thanks, Mike.[ ] I registered at the AHK site you gave, and submitted my query.[ ] However it has not been posted yet b/c they (quite rightly) want to individually vet the first posts from new members before actually posting them.[ ] In the meantime I did some more spade-work...
  12. Deniall

    AutoHotKey for a very simple task

    I am a first-time user AutoHotKey (AHK), trying to get it to give me a shortcut for a text string (my email address) that I have to enter very frequently in all sorts of contexts.[ ] The shortcut I wanted to use was Ctrl-Shift-R, and I expected this would be an easy task requiring only the...
  13. Deniall

    Excel 365- Formula Help - When A1=X and B1=Y, Return C1

    I pretty sure I am missing something here, but the way I read your query would result in the answer to place the formula =IF(AND(A1=x, B1=y), C1, "something else") in whichever cell you are dealing with.[ ] If this is not what you mean can you please elaborate things a bit more...
  14. Deniall

    Problem accessing Eng-Tips website

    Kennabytes.[ ] Many thanks for that simple explanation, which some quick experimentation shows to be exactly right.[ ] I can now trigger the error at will. So perhaps the "fix" that seemed to happen overnight a few days ago was a mirage.[ ] Engineering.com didn't fix anything...
  15. Deniall

    Problem accessing Eng-Tips website

    Now, nine hours plus a good night's sleep later, the problem SEEMS to have been fixed, both on my Windows computer and my Android phone.[ ] No reply yet from engineering.com, but the fix is the important thing (provided it persists). [ ]————————————————————————————————— Engineering...
  16. Deniall

    Problem accessing Eng-Tips website

    Many thanks, Mike and Strongm.[ ] It's nice to know that I am not being ignorant or stupid.[ ] In this matter at least. I have already lodged a message at engineering.com, doing it a few minutes before initiating this thread.[ ] The message was pretty much along the same lines...
  17. Deniall

    Problem accessing Eng-Tips website

    As a bit more evidence that the above problem is not restricted to something on my particular computer setup, a few minutes ago I attempted to log into Eng-Tips using my Android mobile phone.[ ] This triggered pretty much exactly the same error message...
  18. Deniall

    Problem accessing Eng-Tips website

    My apologies in advance for posting this on what is probably the wrong forum, but it looked to me like the least inappropriate. I am a long-time regular user of both this Tek-Tips site and its companion site Eng-Tips.[ ] About 12 hours ago, after working fine only a few hours earlier, my...
  19. Deniall

    Excel An occurance on Sheet #1 - from A:A - want to find the total of $ in G:G ... on Sheet 2

    Am now home, with access to my accumulated files. The site I was unable to rustle up yesterday is www.xldynamic.com/source/xld.SUMPRODUCT.html which is an excellent & all-embracing discussion on the SUMPRODUCT() function. I also attach (the relevant part of) a spreadsheet I developed for use...
  20. Deniall

    Excel An occurance on Sheet #1 - from A:A - want to find the total of $ in G:G ... on Sheet 2

    Your description confuses me considerably.[ ] Perhaps a sample spreadsheet would fill in some of the gaps. Bear the above caveat in mind when I say that I get the feeling you might be able to take advantage of some of the clever uses of the SUMPRODUCT() function. See...

Part and Inventory Search

Back
Top