See this page for a few examples
http://www.rondebruin.nl/last.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"KurtB" wrote in message ups.com...
I am working with a data set that constantly changes length there are
more rows each week. I am writing a macro that inserts a new column
then combines the text from two columns into the new column but I only
want the equation in rows which already have data. If I paste into all
rows it won't sort properly.

For example original data:
Fname lname
John smith
Jane Smith
John Doe
Jane Doe

Modified data
Name fname lname
Johnsmith John Smith
JaneSmith Jane Smith
JohnDoe John Doe
JaneDoe Jane Doe


What macro lines do I need if I want to paste the equation in column
Name only if there is data in column Fname.

Thanks!