pick next blank cell in range to add some values.

hi forum
trying to build a macro to find some values on my sheet and paste them in to a specific range,
but im stuck at the moment because my very little knowledge in vba.

the macro works for the first selection i make . but when i try to search for new value it over write the cell.

i need some code so if the cell in range is not blank move to next the range where i need the values is (a45:a58)

Please Login or Register  to view this content.

hi pierre
i need the destination to be A45 to A58
the code that i have send the value into A45
so the next time i run the macro it should use A46 because (a45) already in use.

Originally Posted by p24leclerc

Then try this:

Please Login or Register  to view this content.

Thank you Pierre for putting me out my misery . i can move on to the next stone.