View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Novicer Novicer is offline
external usenet poster
 
Posts: 2
Default Using the next reference number automatically

Can someone please help me to write a macro that can help me access the next
available sequential number (1, 2, 3, 4, etc) from an existing worksheet? For
example, if Rows 1 - 5 already has data entered already, I want to reference
my formulas to Rows 6 (that is avaialbe) automatically. Thanks!