Hi, looking to know how to copy a formula in e.g. a1 down blank cells until e.g. A10 where A10 contains a value of word. Therefore code would populate cells a2 to a9.
Or can a range range be made to be dynamic as rows will be added or deleted and the formula needs to fill colum A1 between headers and footers etc.
Thanks in advance!
Bookmarks