View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aaron[_17_] Aaron[_17_] is offline
external usenet poster
 
Posts: 6
Default VBA date conversion

I need help creating a script that will take a few ranges of cells
containing dates (A1:A30,C1:C30,E1:E30)
and convert the day in those cells to the last day of the month
(3/12/2010 becomes 3/31/2010)

Any help is greatly appreciated!!