Hi all, new to the site and would really love some help:

I need to insert a number of rows based on the value of a cell:

I have a number in cell A1, and need to insert this many rows below row 1. I then need to copy a formula in cell B1 down this many rows.

I've tried using offset but I can't make it work. Very new to VBA, so any help would be appreciated.

thanks
Phil