Recent content by Davidprince

Thanks Skip, great solution as always...you are a star. Just shows how much Excel I have forgotten.

Ladies and Gents A Merry Xmas. I have copied data from a pdf and have this type of data in an excel2007 cell: K098768 J7685 I want to leave the cell as K098068 or have the same result in an adjacent cell. I seem to recall a similar problem on your website some years ago, but it involved...

I reformatted the hard drive on my desktop computer with Vista Ultimate and now have a problem accessing the internet from that machine. In Device Manager the Network Adapters (Realtek RTL8101 Family PCI-E Fast Ethernet NIC has a yellow warning on it (other devices SM Bus Controller is showing...

Ladies and Gentlemen I am looking at writing a program to emulate a card shuffling machine. What I know of the machine is that it uses a system whereby the cards are stacked into a slot. There are 53 of these slots. My question is, would it be more efficient to use stacks (clearly designed for...

Hi Skip Thanks for the comments....quite right, the explanation wasn't detailed enough. The list below may make it clearer: Number G H I J 27 29 8 11 29 a b c d 11 27 29 2 1 29 8 36 formula in cell a is...

Ladies and Gentlemen I have a table of 10,000 numbers. I am trying to work out a formula that will look up a table based on the result in the list of numbers. Initially I am looking at the last five results, wanting three occurences but may want to test for 6 or 7 numbers (with three...

Hi PHV Thanks for the quick response. I should have read Dan Fox's Pure Visual Basic book a little more closely...or at least used the index. Cheers David

Ladies and Gentlemen This is a follow on from my last question, but unlike the last post this gets to the heart of the matter. My apologies for not thinking of this before posting the earlier query. I have found lots of valuable information on arrays and one example that, whilst obvious in how...

Ladies and Gentlemen Thanks for your responses. MajP, I am aware of the articles and several others on the web, but appreciate the input. Skip, spologies for not uploading the code. I need to reduce it down before doing so, as all my scribles are included. Hope to have that sorted by Thursday...

Ladies and Gentlemen I have an array of letters, after having set up data on an Excel spreadsheet. Copied the array into VBA as normal and have been able to count the number of times each letter occurs and display this on the spreadsheet. The data looks like this: Letter...

Ladies and Gentlemen I am completing a program in VBA and am wondering if there is a way to solve a problem within the code. This section counts up the number of occurrences of a letter occurring in a range. The problem is the range expands one cell at a time until the count for any letter is...

Ladies and Gents Another problem involving settling a bet. My friend has come up with a scheme for beating a roulette wheel (I tell him every 6 months or so he is mad, he still comes up with ideas!). Anyway, I had set up a spreadsheet where he could feed in the results (generally limited to 300...

Thanks Macropod, I apologize for not persisting with your solution. I finally got it working after several botched efforts. This will please the computer illiterate users at the office. Regards David

Ladies and Gentlemen Thank you for your prompt responses. As an interim step I am triallng the Excel spreadsheet using the date in text format so that the mail merge picks up the actual date rather than one contrived by microsoft' rules. The other soluton of course is to write amail merge progam...

Ladies and gentlemen This seems fairly trivial and I apologize for the question if that is the case, but my extensive searching of Micrsoft and other sites has failed to find an answer (there may indeed not be one). I am doing a mail merge with data from Excel and a Word letter. I would like to...