How to write a macro that searches across row one for a comment in a cell containing #LAST_COL selecting the cell before that
and down the first column for a #LAST_ROW and selecting the cell before that for a copy?

Row 38662 contained the #LAST_ROW comment
Column CQ contained the #LAST_COL comment

Starting point will always be cell A5

Using developer tool and recording macro ended up with
Range("A5:CP38661").Select
Selection.Copy