View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JCarter JCarter is offline
external usenet poster
 
Posts: 6
Default VBA to Concatenate and Autofill??

I have a issue where 3 separate columns (A - C) have pieces of dates in them.
Month (A), Day (B), Year (C).

What I need to happen is to Concatenate A-C, then Auto fill down as far as
necessary, and then go back and Copy Paste As Value to remove the formula.

Can anyone provide coding guidance on this? I would greatly appreciate it!!
--
JCarter
Still Learning