View Single Post
  #3   Report Post  
Old March 9th 10, 09:17 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 Mike. I really need a macro.
I am using some macros and i need to use this macro along with the other ones.
But i really don't know how to make this work.
Can you help me with a macro?

"Mike H" wrote:


Yuo can have a macro if you want but you don't need one, try this


When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the

"puiuluipui" wrote:

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.

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

Can this be done?