Hi,
I have a range of data set and when I insert a new line this range then includes the line. I then would like to use a macro to say once that line has been inserted copy down the formula from the first row of the range all the way down the range to the last row within the range so that the formula all work correctly as if the cells had been copied down via dragging them.
Any help would be great
Many thanks
Bookmarks