| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement checking list | Excel Worksheet Functions | |||
| Checking whether a value in a list is present in a second list | Excel Discussion (Misc queries) | |||
| checking for a value in a list | Excel Discussion (Misc queries) | |||
| Checking if value is in a list | Excel Worksheet Functions | |||
| Checking the last character is in a list | Excel Programming | |||
![Donny[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
