Can't open extra Excel sheets without a debug error

[mikedmc]

Hi,

More help please .

I have my scripts working well now, albeit a few little niggles. However one such niggle is more annoying than all the rest, whenever I open another excel sheet it crashes my vba script, normally out of range error and the debug dialogue.

Only closing the new excel sheet fixes the problem. Any ideas why this is?

Thank you.

[Ian]

Your scripts need to specify the workbook and worksheet in the code.

eg if you use just Range("A1") then the script looks at A1 in the active sheet of the active workbook.

[alrodopial]

Instead of Range("A1") you should use Workbooks("MyBook").Sheets("BF1").Range("A1")

[mikedmc]

Thank you, thank you, thank you and thank you