"Peter T" <peter_t@discussions wrote in message
...
Actually your original code seems fine, providing the active (selected)
cell
is K2, thereafter everything is relative. In your OP you say when you
select
K2 the CF formula refers to T2, that would imply when the CF was applied
A2
was active which seems odd looking at your code.


Hi again Peter, thanks for your patience. At runtime, in the immediate
window, when I paste

?objXL.Intersect(objSht.Range("K2:IV65536"), objSht.UsedRange)

I get a "Type mismatch" error. Any ideas why that might be?

Regards,
Keith.