View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
C C is offline
external usenet poster
 
Posts: 61
Default Need VBA for for column addition and on condition resets to 0

I have a spreadsheet that I need to increment Column X by one when the macro
is executed. When Column x = 12 then it goes back to 0 and column w is
incremented by one.

Note: Only column x resets to 0. column W increments to infinity.

Example:

March 2009
Column W Column X
10 11

April 2009 After Calculation
Column W Column X
11 0

May 2009 After Calculation
Column W Column X
11 1

Can someone help?

Thanks in advance.
CB