Identify missing numbers

Hi, I've altered the code because it didn't like your large numbers.
The missing numbers are now placed in column offsets from column "A"
I have run it with you numbers and it works except you have, in one place 800 numbers missing which rather exceeds the columns available, but with 2007 I think you have got a few more to play with.
Have a go with this, see how you get on.

Please Login or Register  to view this content.

Regards Mick

thanks for that, much appreciated... however, i cant seem to figure out how to use the code, whenever i paste it into visual basic and select run, it asks me to create a macro... i choose a name and select create... it comes up with an error message saying:

INVALID PROCEDURE NAME?

Can you please help?

Thank you

Regards

SWM

Hi, Try a Command Button
----------
Inserting a Command Button in worksheet and Allocating Code

Open your workbook at the Sheet Number with your Data that you want to Manipulate.
Click View, Tools, Control Box,---- Control Box Menu Appears on sheet.
Slide you cursor over the Tool Box until you find a Command Button.
Click It then click Somewhere on the sheet.-- Command Button appears on sheet.
The Command Button will have handles round its edge, This is so you can Position it on the sheet.
Click the command Button "Hold the Mouse Click Down" and Drag the Command Button to where you want it.
Double Click the Command Button, The VB Editor window will appear.
You can also open the Editor By clicking Alt + F11, but if you double click the Command Button the editor will open in the procedure relating specifically to your Command Button.
If the VB Editor window has two panes the right pane is where you must paste your code.
The left pane can be "Project Window" or "Properties Window, Click "Ctrl+R" if not showing.
Paste your code just under the words "Private Sub CommandButton1_Click() " in the Right hand pane.
If you have done this correctly. Scroll to the bottom of the code and you should see the words "End Sub"
On the VB Toolbar you will see a Green Triangular shapes icon,.
This is to change the VB Editor mode from "Run Mode" to "Design Mode "
Click this Icon, The Small blue square to its left will change from light blue to dark blue, or Vice Versa. Before you close the Editor make sure this Square is "Dark Blue" i.e. (Reset)
Sometimes the it will appear Reset when it is not, that why I usually put a message at the bottom of the code, to know if is run or not.
Close the Editor. Select the Command Button and Click it.
When the code Runs the Msgbox should appear With The Message "Transfer Complete" ,if this doesn't happen Open The VB Editor "Alt + F11" and click the "Reset ( Blue Square) and or The "Green Triangle" on the Tool bar . The Blue Square should be "Dark Blue ", in order to run the code..
NB:- If you want to get back into this specific code through the Command Button.
Get the Control Box menu back on the screen, Click the green triangle, When you slide the cursor over your Command button , The cursor shape will change to a "Arrow Headed Cross" , you will then be able to double click it to view your code.
If you prefer, you can forgo all this hassle by putting the code in an MT macro, with a key combination like (Ctrl+"A") to run it.
If you still get a problem , call back
Regards Mick

Awesome, thanks for that... it worked first time!

Do you know how i can pull all that data into one column or will i have to do it individually... eek!

Thanks again for all your help!

Regards

SWM

Hi, Do you mean all the missing numbers, if so where would you like to put them, considering in one case there were 800 of them.???
Regards Mick

I would like to place them in the next sheet i.e. sheet 2 and all in column 'A'.


once i have dont this, i will add them all to the original numbers, sort them and run the script again to find the remaining missing numbers...

Thanks

steve

Hi Steve,
Try this:-

Please Login or Register  to view this content.

Regards Mick

Genius... total genius...

Thanks a lot!

Regards

swm