Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Entry in Colum
Want to use a macro to find the last entry in a colum that can change every
time its run. Any ideas or sample code appreciated Roger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Entry in Colum
Dim LastCol as long
with worksheets("Sheet1") lastcol = .cells(.rows.count,"A").end(xlup).row msgbox .cells(lastrow,"A").value end with I used column A. hawk wrote: Want to use a macro to find the last entry in a colum that can change every time its run. Any ideas or sample code appreciated Roger -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sum a column only when an entry exists in a different colum | Excel Discussion (Misc queries) | |||
how do I write a formula to select the last entry in a colum | Excel Discussion (Misc queries) | |||
Sum and Offset: to add from a point to the last entry in the colum | Excel Worksheet Functions | |||
Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) |