View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Create a macro to move info from one column to another

You need to make the macro be in a "For...Next..." or "For...While..." style.
add your recorded macro to a response and people can show you common ways of
expanding it to be more general.

"John" wrote:

I have a list that has first names and middle intiials in the same column. I
want to create a macro to cut the initial and the period and paste it into
the next column over.

I have recorded a macro that does it, once. But I don't understand how to
get it to keep working through the whole list.

Thanks.
--
John