View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pkeegs pkeegs is offline
external usenet poster
 
Posts: 46
Default Increase date by on year

I have a macro which clears last years information and makes the worksheet
available for a new year. I want the Macro to increase last year's balance
date by one year. How do you get the Macro to increase the date value of the
active cell by one year?