Hi,
Does anybody know how to make a macro that will do the following?
Do a special paste value with Column B and Column C and Column D.
Column B = I
Column C = Love
Column D = You
So Column B comes out "I Love You"
But I would like to this with all of my rows in these columns.

I was thinking something like this
hard code this formula =B2&" "&C2&" "&D2
copy this code
and then special paste value this code into all the rows. Of course
all rows will be different text

--
jcc3
-----------------------------------------------------------------------
jcc31's Profile: http://www.excelforum.com/member.php...fo&userid=2469
View this thread: http://www.excelforum.com/showthread.php?threadid=49087