The ranges shown are absolute so what offset are you trying to apply ?
Sounds like you might need to change the destination range to row 20 ?

Cheers
Nigel

"gavmer " wrote in message
...
Thanks so much...exact!!!

Can you amend, possibly with an offset. I am using a sum function and
it is moving the range down???

Cheers!!!!!


---
Message posted from http://www.ExcelForum.com/