View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
akcaster
 
Posts: n/a
Default Programing max and mins into a spreadsheet

I am working to add a max and min feature to macros for adding and deleting
colums and rows with a worksheet. For example, through a marco allow adding
up to 10 colums to a worksheet and allow to delete only the added colums
through a separate macro. The same would go for adding and deleting rows in
the worksheet.

Any vb sample language would be helpful. It seems that the intCounter
feature would be useful; but it looses its value when the worksheet is closed
and reopenned.