View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KUMPFfrog KUMPFfrog is offline
external usenet poster
 
Posts: 38
Default apply next number in newly inserted row

I have a CommandButton that Inserts a row in a particular location. I would
now like to continue the macro to search col B for the highest number and
then apply the next number to cell of col B in row just inserted. Note - the
numbers in col B are not always in order on the list.

Thanks for any help given