Sep 09 2024 11:24 AM
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?
Sep 09 2024 11:54 AM
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