View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dono Dono is offline
external usenet poster
 
Posts: 5
Default trying to create a blow-up sheet by writing a VBA macro

Hello I am trying to create a blow-up sheet by writing a VBA macro that shows
the initial cost buy of an item then for a range of years, the Maintenance
cost for each year.
e.g.
PC Cost by is $2000 bought on 4/2005 and for the next 4 years the
maintanence cost is $100 per year.
so it should appear as:

PC $2000 4/2005
PCmaint $100 4/2006
PCmaint $100 4/2007
PCmaint $100 4/2008
PCmaint $100 4/2009

I imagine it will be a FOR or WHILE with some ARRAY type variable

Thanks