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!

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

Recent content by notuserfriendly

  1. notuserfriendly

    Autofilter error (multiple criterias)

    You're right about that, but since I kept getting errors I didn't find it too helpful although it helped, what I had a problem with then was using Ws. I kept on getting the same error. The last posted code did not work without errors. Tried to use Set Ws = Thisworkbook.Worksheets(SheetName)...
  2. notuserfriendly

    Autofilter error (multiple criterias)

    What I really had a problem with was doing it like this. I think, that's why I get the error. Want to use Ws because there are many sheets => less code. Dim Ws As Worksheet Set Ws = ThisWorkbook.Worksheets("Sheet4") If Ws.AutoFilterMode Then Ws.AutoFilterMode = False...
  3. notuserfriendly

    Autofilter error (multiple criterias)

    found it: http://www.contextures.com/xlautofilter03.html but: If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False End If
  4. notuserfriendly

    Autofilter error (multiple criterias)

    I noticed that the error emerges when filtering the second field. If I change the order of the filterings. It's always on the second filter that creates the error.
  5. notuserfriendly

    Autofilter error (multiple criterias)

    No It didn't help. Get the same error. Does the filter only work if you have a value after doing the first filter? Does one have to disable events or? Kind of clueless on this one
  6. notuserfriendly

    Autofilter error (multiple criterias)

    Hi I'm having problems with this ThisWorkbook.ActiveSheet.EnableAutoFilter = True If ThisWorkbook.Worksheets("Sheet4").AutoFilter Is Nothing Then Rows("1:1").Select Selection.AutoFilter End If Selection.AutoFilter Field:=1, Criteria1:="<>*XX*"...
  7. notuserfriendly

    Domains behind ip address?

    I suspected that it was kind of difficult but wanted to know if it was easier than I thought. Thanks
  8. notuserfriendly

    Domains behind ip address?

    Hi I'm wondering how to find out/get a list of all domains connected to a certain ip address, is this possible to do? /I
  9. notuserfriendly

    Updating window?

    Hi I'm wondering how to make Excel responding when it's in a sub or function. I've got a function that is supposed to handle up to 10 000 items. The problem is not calculating, the problem is that after a while Excel works kind of a lot and when using other applications at the same time...
  10. notuserfriendly

    Opening xls from a different version of Excel

    If Application.CalculationVersion <> _ Workbook.CalculationVersion Then Application.CalculateFullRebuild End If
  11. notuserfriendly

    Excel keeps crashing when spreadsheet is used

    The information you give doesn't say that much. Some code or adding more precise information would help a lot. For example do you open all worksheets when using the macro or does it open and refresh the queries automatically? 1) The combobox issue I really don't know, never had that problem...
  12. notuserfriendly

    Opening xls from a different version of Excel

    Hi I'm wondering how to cope with the question given by Excel to recalculate the formulas in the opened .xls (happens when an Excel workbook is opened by someone with a newer version of Excel). Do I have to remove alerts and open the file or is it some way to open the file and answer the...
  13. notuserfriendly

    set focus?

    Made it, seems as I missed .checked == true, don't get why it worked once but not in the rest of the loop.
  14. notuserfriendly

    set focus?

    allthough I just noticed that there's something strange in the loop. Since the code after the loop doesn't get executed. Btw it's else if. sorry for all the typos in the code.
  15. notuserfriendly

    set focus?

    Meant this actually works, (doesn't check anything though, but just wanted to see if it was possible), and it will be kind of ugly coding every week like this when I get to next year. document.getElementById('onv[45]').focus(); document.getElementById('onv[46]').focus()...
See more

Part and Inventory Search

Back
Top