Hi I was wondering if anything obvious stands out why this is only copying to the first blank row and not the range ive tried to define

newrows comes out to 3 which is the records set / 9

so I want to add 2 new rows of formula

lstart is 59 which is correct - my last row of formula
lend is 60 which is correct
lrowA is 61 which is correct

extract of code below

thanks gws

Please Login or Register  to view this content.