autofill code

[mubashar]

how can i use this code in a sheet that Destination range should be first asked through input box , and then it will autofill that column, the values given by inputboxes

Please Login or Register  to view this content.

ie first inputbox gets value for F1 and second inputbox gets value for F226 or whatever i want to give in inputbox.

[stnkynts]

try this:

Please Login or Register  to view this content.

[mubashar]

dear stnkynts when i run this code, it will ask me again and again for input box values , i want it will ask for r1box value and then r2box value and then perform his task and stops the code, but it again ask for r1box value . plz correct it

[stnkynts]

It should only be prompting you for the 2 ranges once, each time the code is run. If it is prompting you multiple times then you have done something incorrect such as putting the code as part of a worksheet change procedure.