View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bull Bull is offline
external usenet poster
 
Posts: 26
Default Type date in first cell of row, 13 columns over - auto extractsmonth for each row

Quick questions:

How can I put Code in a Worksheet (on Selection change), where for
each row, I type 11/15/08 in the first cell, and in column "M" of the
same row, the 11 is inserted from the date in column A.

Example:
In row 66,
I type 11/15/08 in Cell A66,
In Cell M66, 11 is automatically extracted and inserted

What is the code for doing this for each row, not just row 66, all
rows.

Thanks.
Bull