vba help to apply formula down till end of row data and where ever is blank in range.

Dear experts


I have excel formulas in excel sheet with in a range of B2:E2 i have to pull down formula with out pasting on already existing data in that range.
data in A:A column get blank and get the row end some where in A:A !!
if i run the code apply formulas from A:A column end of row data till there where ever blank in that range B2:E2 that only make apply formulas down.
once data end row in A:A column make the running code stop..

msg box should be "task completed"

find the attachment you may have understand !!!