I need to find the bottom cell of list that is always getting longer, through VBA.
A macro is first run to sort the data alphabetically.
e.g.
A
NAME
Bob
Frank
John
Mike
...I need to get "Mike".
BtnName_Click()
Dim Row as Integer
Dim Names as Object
Set Names = Sheets("Sheet1"
.Cells
While Not IsEmpty (Names(Row, 1))
.... something something.
A macro is first run to sort the data alphabetically.
e.g.
A
NAME
Bob
Frank
John
Mike
...I need to get "Mike".
BtnName_Click()
Dim Row as Integer
Dim Names as Object
Set Names = Sheets("Sheet1"
While Not IsEmpty (Names(Row, 1))
.... something something.