Search results for query: *

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

Can you scan the document with your anti virus software. If not try putting document on to a floppy (if you have one of those) or a cd and scan the floppy or cd with the antivirus software. Regards David

Crazyf Ntest = InputBox("Please enter a number between 1 and 100") If Ntest >= 1 OR Ntest <= 100 then DO SOMETHING HERE Else MsgBox "Please enter a number between 1 and 100" Regards David

strongm Thanks for the tip - I should have looked at one of my old posts first, which would have lead me to your reposted faq. Regards David

Ladies and Gentlemen I have the following code to do some card shuffling in an existing program (borrowed off the net about 3 years ago). I have had the program running with two decks (104 cards) but the bloody Casino has now gone to 4 decks (208 cards). I thought that's easy just change the...

I think this may solve your problem but am unsure as to how quick it is. If you search: convert+VBA+program+to+VB in Dogpile Item 41 on the resulting list is: Covert Database Data Between Serveral Format - visual basic, vb, vbscript Note: the misspelling of Several is correct. This will get...