Any way to remove the array like so

I have cells B2:F2 with this forumla.

{=TRANSPOSE('Data 1'!B66:B70)}


I want a the cells to convert to this

B2=B66
C2=B67
D2=B68
E2=B69
F2=B70


I need a vba snippet to do this across a large range. I know I could edit each cell but there is 62500 cells.

Jay,

One way would be to have a couple of nested loops. Such as,
for i = 1 to 250
for j = 1 to 250
create the new formula using Range/Cells .Formula / .FormulaR1C1 = "new formula"
next j
next i

For simplicity, if you post the range details someone might detail it if you need.

regards,
Fazza