View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
zach-18 zach-18 is offline
external usenet poster
 
Posts: 1
Default How do I concantenate two columns for the length of a table?

I have a daily report in which I need to combine the 1st and last name. I
would like to write a macro that would concatenate the report, regardless of
the number of rows. If the 1st name is in Col A, last name is in Col B, and
the combined would go in Col C, what would the VBA text look like?

Thanks and Kind Regards in advance for any help.