Runtime Error?

[algallus]

I am running a macro in Excel, with this piece of code:
........

Hoja6.Activate
Range("A:G,I:I,K:K,M:M,O:O,Q:Q,S:V").Select

................
When it runs freely, a runtime error occurs at the Select instruction, but when run from the "debugger" it works perfectly.

Any ideas??

Thanks in advance.

 

[Richard Schollar]

Hi Algallus

What is Hoja6 defined as? Is it a worksheet/workbook? What is the active workbook in Excel when you run this code?

Best regards

Richard

 

[Andrew Poulsom]

How are you running the macro? If from a CommandButton from the Control Toolbox, try setting its TakeFocusOnClick property to False.