Recent content by notuserfriendly

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)...

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...

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

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.

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

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*"...

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

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

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...

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

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...

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...

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

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.

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()...