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.
Does anyone know if there is a better / alternative way of doing this that will allow me to extend the range without the error?
Please Login or Register to view this content.