Pls any one help me.

I have a range of cells from B35:E42 named (Range1)

Is there any way to copy the formulas in B35, C35, D35 & E35 to the end of
the row that is Row E

ie:- Copy the the formula from B35 till B42, C35 till C42, D35 ti D42 and
E35 to E42.