SAP recorded code to compatible with VBA

Hi All,

I have multiple numbers which needs to be entered in SAP, below is the recorded code however this runs only the given number, how do i loop until the last runmber in column A of an excel sheet

session.findById("wnd[0]/usr/sub:SAPMF05A:0731/txtRF05A-SEL01[0,0]").text = "123456789"

Thanks for any help provided.