Cut and paste a range of cells based on user input

Hello,


I'm new to VB and was looking for some help, any input would be greatly appreciated...


the cells A1 to H1 contain a bunch of values:

1 11 59 35 33 46 12 18

I need a code that allow the user to add a number to that list and also specify where it goes..

B3= what number to add
B4= after which number

example :

1 11 59 35 33 46 12 18

B3= 60
B4= 59



the result should look like this


1 11 59 60 35 33 46 12 18




Like I said, any help is greatly appreciated....thx

Here you go !

Please Login or Register  to view this content.

Here's another possibility.

Please Login or Register  to view this content.

Thank you ALL very much for your help, both Fergo and Skywriters codes worked well, but skywriter's code allows me to input letter in also which is what I need. the Berlan solution did not work for me but thanks for helping...

Michael,

I forgot about one of the behaviors that the find method has. If the first two numbers A1 and B1 were the same and your intention was to put the new number after A1 my code will in fact put it after B1. It's an easy fix.This is the modified code you should use.

Thanks for the rep. points.

Good Luck.

Please Login or Register  to view this content.