View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default How can I custom autofiller with VBA

Hi I am John.
I am using 2003 and would like to be able to locate last number in column
"A" copy it and add 1 to it. Example.. 010970 current in lastrow cell A24.
I would like cell A25 to autofill with 010971 when worksheet is opened. I
know this is something simple but being new to excel I am having troubles.
Thanks for all your help!