Hi,
If column B had data ranging from Row 1 to Row 100 say, I would then want my
range in Column A to increase/decrease to match the number of rows Column B
encompasses.

Can someone help with a VBA code to do this for me?

(The Range would consist of formulas that work off the data in Column B)

Many Thanks

John