sorry too early in the morning.

Right now I have it so that someone can put their address in cell A-D. We
need to have it this way as we are are bringing the addresses in from a
database.

So Address is A2, city is B2, State is B3, Zip Code is B4. In b5 we
combine the addresses as we need to put that in another chart.

right now its programmed to read the entire worksheet and combine all the
lines till the last line. I just need it to run the one line not do the
entire document. so I just need it to run row 2 not all.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200906/1