Hii All
The following code works fine:
range("F12").Copy
range("F13:F" & lrow - 1).PasteSpecial (xlPasteFormats)

I tried to reduce it to the following and it gives an App error:
range("F12").Copy range("F13:F" & lrow - 1).PasteSpecial(xlPasteFormats)

It seems to be quite happy to accept the line of code when I type it in.
Where is it wrong ??
Any advice is appreciated
Regards
Michael M