View Single Post
  #1   Report Post  
Old March 9th 10, 08:58 PM posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 468
Default macro to generate next number

Hi, i need a macro to look in sheet 2 column A and look at the last filled
cell. In the last filled cell i have a number. When i run macro, i need to
generate (in sheet1 A1) the number from the last filled cell +1.

EX:
sheet 2 last filled cell = 29
sheet1 after macro i need to have in A1 = 30

Can this be done?
Thanks!