On 26 Nov, 11:58, Nattasiray
wrote:
Dear

You must change the code to:
Range("AV" & [Av1]&":AV" & [Av1]).PasteSpecial xlPasteValues

[] Is Evaluate Method


Thanks for the reply but still gets error from VBA. What do you mean
by [] Is Evaluate Method? Do I need to put that in the string?

Brgds,
Harald