Search results for query: *

Hello all, I have a Fujitsu Siemens LOOX N560 PDA runnnig windows mobile 5.0 and I want to connect a serial device to it. The LOOX has a USB connector but no serial connector. The cable with this connector is not available anymore (as far as i can tell). I have tried using a USB to serial cable...

hello all, I have a problem with conditional formating that I need some help with. I have two workbooks with the same layout. I want to be able to compare the differences between them by highlighting any cells that are different by changing their colour. The data is in the range ("b7:o29") I...

Hello everyone. I have a workbook with multiple sheets and I want to create one pivot table using the data from all the sheets in it. I can create pivot tables on the individual sheets easily enough but not my 'super' pivot table. I get an error message when I try to select multiple sheets in...

Hello everyone What I want to do is copy a list of values from one sheet to another ( range("b2:b52901")) but I want to add a value to it depending on the value from a for..next function ex x=0 x=1 x=2 sheet1 sheet2 sheet3 1 2 3 2 3 4...

Hello I am having a problem with my windows 2000 computer which is causing me to want to break it - please help me!! The problem occurs when I want to use the network it is connected to. I obtain licences through flexlm for the software that I run. After about five minutes of use an error...

My friends PC has gone wrong!!! On start up the 'safe mode' normal mode menu appears. Selecting normal from the list carries on the boot and then returns the system back to the 'safe mode' ' normal mode' menu. I have tried all the options available in this menu and it always loops back. There is...

Hello Everyone I am trying to use intersect but cant get the code right. What I have is to rows of data from a1 to m2 row 1 acts as a header row to as the data I have inherited a program which uses intersect to pick up the information required in the range c1 to m3 using the following code...

I have a macro that creates an increasing number of sheets as it runs. At each step it searches through these sheets to see if a certain one has been created in the workbook. Several workbooks are used in this macro and the code cycles though depending on the workbook. I want to speed up this...

Please Help, I have written a macro in excel and saved as normal etc before closing down. Now when I want to open my file I get a white screen in excel and then it closes and I cant do anything. I dont care about the content of the file except for my program. Is there any way I can get the macro...

Please Help, I have written a macro in excel and saved as normal etc before closing down. Now when I want to open my file I get a white screen in excel and then it closes and I cant do anything. I dont care about the content of the file except for my program. Is there any way I can get the macro...

What I am trying to do is colour code cells according to the value contained within. I understand this is possible to do this with conditional formatting but this can only have three ranges per cell. I have ten. The data is placed in another part of the sheet and in the section I want the colour...

Hello I want to increase the size of my virtual memory. I am using NT 4.0 on my workstation with 4GB of physical RAM. I have increased the virtual memeory to its maximum of 4095MB and windows wont let me set that any higher. The reason I need so much memeory is because I have created a model...

To all who helped me with my Macro My macro is now complete and has been accepted by my boss and some other managers. I would just like to thank all of the people who helped along the way especially RobBroekHuis, Nikita and xlbo with whos help i couldnt have done this I have learnt a heck of a...

is there anyway of saving to a particular location everytime? - This location will have to be specified by the user the first time that they run it. I have the saveas dialog box but apparently this has too many button clicks. Any way to bring up the same folder everytime? Thanks andrew299

Hello again I want to create a sort of status bar for my macro. I have the code that calculates the percentage complete but how do I display this? I thought first of all about msgboxes but dont want to click OK everytime (could be 400 times +). So I thought ahh! userforms - created one that...

I am having a problem with usedrange I want to count the number of cells in a column for the purposes of a loop I am using ActiveSheet.UsedRange.Select cellcount = Selection.Rows.Count The trouble is the usedrange seems to pick up cells where there is no data. There may have been in the past...

iS IT POSSIBLE TO DISABLE A COMBO BOX? MUCH LIKE YOU CAN DISABLE TICK BOXES? Thanks Andrew299

is there a way of searching for a sheet of a specific name like cells.find but sheets.find I cant find one thanks andrew299

Ok here is my problem, I have completed a search for wildcards in my macro and now want to use this wildcard variable to pick out any cells containing anything similar by that I mean the first few letters match wildcard = dav therefore will pick out david, dave or davina in my worksheet her...

Thanks to Geoff I can now add a wildcard search into my macro the trouble is it now has to create a sheet with the search name in it. Is there anyway of changing a variable to remove the * only i.e sheetcode = AAA* sheets.add activesheet.name= sheetcode This is how I do it at present What I...