Macros and VBA

Copper Contributor

My old macro  won't work in windows 11.  Specfically the command that allows you to go to the bottom of a long list no longer will compile.  What is the command for this function?

1 Reply

@dhinz805 

What is the code that won't work?

Code like this should still be valid:

    Dim FirstCell As Range
    Dim LastCell As Range
    Set FirstCell = Range("A1")
    Set LastCell = FirstCell.End(xlDown)
    ' If you want to select that cell
    LastCell.Select