View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Change cell value to next in series upon opening worksheet?

The code can be modified to produce letters (e.g., concatenate "M" with
the sequential number).

That's the easiest method I know. I don't deliberately suggest
harder/more complicated solutions...

In article ,
Connie wrote:

Thanks for the link... I am studying it... but, is there an easier way to
automate incremental updates of a cell (especially because it includes
letters, and the code looks like it requires a number format)?