View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Donny[_3_] Donny[_3_] is offline
external usenet poster
 
Posts: 6
Default Making a List (and checking it later)

I'm trying to make a list. Say I hit a button and it generates a
random number in cell C1. I want to make another button that copies
that number and pastes it at the bottom of a list in column F. I can
count the number of values in column F, but I don't know how to make a
reference to the cell below the last number counted. Does anyone know
how to do this easily, possibly with little VBA code? After I make the
list, I will be able to search it for max, min, and things like that.
Thanks!