Search results for query: *

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

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

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

Hi I've got a form that is supposed to show an extra column field if the users makes the a certain choise, this is done by if(strcmp($rowP["v$i"],"1") == 0 ){ $on = "checked "; } echo "\t\t<td><input type=\"radio\" name=\"v[$i]\" $on onfocus=\"this.checked;hideReason('v[$i]');return false;\"...

Hi Im protecting my sheet by ThisWorkbook.Sheets(Sheet).Protect Password:="pass", _ AllowInsertingRows:=True, _ AllowFormattingRows:=True, _ AllowDeletingRows:=True, _ AllowInsertingColumns:=False, _ AllowFormattingColumns:=False, _ AllowDeletingColumns:=False, _...

Hi I was just wondering. It seems like there's actually a bug in Excel. Example: hiding all columns but A,B,C entering like values: 1-6 on rows 1-6. Then add a comment to the cells. You will notice that the formatting of the cells changes when you put your mouse over the cell with comments. It's...

Hi I'm trying to find out how to hide and show a grouping (columns). Trying to use outline but doesn't seem to work. ActiveSheet.Outline.ShowLevels 2 ActiveSheet.ShowDetail = False Anybody?

Hi I'm wondering if there's a way to see what the debugger sees in the stacktrace or if one can see the name of the running sub or function when wanting to log to a file. Is there a way ?

Hi again I'm having trouble with .ClearComments It doesn't clear the comments when the sheet is locked. I've tried to unlock it but still the same problem. Any ideas?

Hi, I'm wondering why my sheet behaves strangely. I'm trying to protect some parts of the sheet. There is one problem though. After running this code the range is locked. It happens after .ClearFormats is run. I've been trying to change it with .Locked = False for the same range but it's no...

Hi I've got a sheet where the first five rows are supposed to be protected. I've done it by selecting the rows that are going to be protected and protected them and then the sheet. The problem now is that when pasting data from other sheets the rows containing the new data are locked too. Help...

Hi I just noticed that after hiding some columns on the outer right of my sheet. (trying to hide all columns that doesn't have anything to do with the sheet) I get a strange error when trying to group some other columns. I get the error "Object can't be moved outside sheet" or similar since I...

Hi I'm trying to write a sub or function that handles validation on all cells in a specific column. I would like to skip the hardcoding as in the example With Range("e5").Validation .Add Type:=xlValidateWholeNumber, _ AlertStyle:=xlValidAlertInformation, _ Minimum:="5"...

Hi I'm wondering if there's a nice way of uniquely identifying an apache server or php installation. I want to use my code on different servers and need to find a way to know which server the code is running on. I

Hi I'm using a a form with several ComboBoxes. I'm trying to make the comboboxes change each other, so that they can't have the same value. My problem is that i want to disable the event when I change the Listindex. Otherwise it all goes wrong. When I'm in my first CBX_change() this results...

Hi everybody i've got a problem, I load a sheet into an array every sheet is indexed 0 to n every row is then also given an array Array(index)(index2,index3) according to the debugger It says that the size of Array(index)(index2) is X the problem is that I want to loop thru index2 but I can't...

Has anybody succeded in doing this. Can update text but when I try with the blobs it doesn't work. Running (Testing) on a Win XP, MyOBDC 3.51, IIS 5. the error I get is: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Query-based update failed because the row to update could not be...

Hi I'm trying to find out why my macros work great while working in Excel only and why they stop when working in other applications. Would like to know if there's a way to see if ESC is sent to Excel when not having the program active. Some operations take a lot of time and I would like to be...

Get this from message from Excel. Has no error code. And only happens sometimes. I suspect it has to do with running other applications while Excel is busy working with a high percentage of CPU. In my case it searches in other excel sheets for information and closes every file it searches in. By...