Hello happy Thursday!!

Instead of having: A range in the same worksheet starting in column "A" as
shown below, how can I tell the program that I need the Range "A" from sheet
2.
I tried: Range(Sheet2:A .......) But did not work. Anyone???

For Each myRecord In Range("A80:A" & _
Range("A" & Rows.Count).End(xlUp).Row)
'For Each myRecord In Range("write_this")

Thanks alot in advance