Runtime error 1004: Method 'Range' of object '_Worksheet' failed

Hello,

I realise there are a number of posts on this topic and I have reviewed them but cannot find exactly what I am looking for.

I have a macro that works well until I extend its range at which time I get the error 1004. The code range goes out to column EN:EN but the problem occurs when I extend the range(s) to cover "EQ:EQ" see code below.

Please Login or Register  to view this content.

Does anyone know if there is a better / alternative way of doing this that will allow me to extend the range without the error?

Thanks.

Excellent.

Thank you protont (and Norrie) it worked perfectly.

Thanks again.