| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the last entered value in a column
Hi,
I would like to find the last entered value in a column. For exemple: I have a range in column A from A1 to A99. If someone put in a value in cell A100, I would like to find the value and put the value in another cell B5. Can someone help me? --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding the last entered value in a column
Range("b5").Value = Sheets("intro").Range("a65536").End(xlUp).Value
--- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding most recently entered number within a column | Excel Worksheet Functions | |||
| FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA | Excel Worksheet Functions | |||
| Finding replicate data in a column accidentally entered | Excel Worksheet Functions | |||
| Finding total via entered text | Excel Worksheet Functions | |||
| Finding the last row entered | Excel Worksheet Functions | |||
Hybrid Mode
