Understanding Workbooks.Worksheets vs. ActiveWorkbook.ActiveSheet

[foolios]

I can not get around why it is that I can't ever get the line or any similar lines such as:

Workbooks("InsertColumn").Worksheets("Sheet1").Columns(x).Insert

where the workbook name is InsertColumn,
to work with that specific Workbook. Or the problem might be that specific sheet. I'm not sure...

But if I use lines such as:

ActiveWorkbook.ActiveSheet.Columns(x).Insert

I dont' have an issue with that line other than I'm afraid that the line won't execute if the particular sheet isn't the one that's currently active.

Can someone please explain to me the difference? Is it a scope issue? What is the difference and why?

Thanks so much in advance.

 

[Norie]

In the first piece of code you might be missing the extension for the workbook name.

When I try and refer to a workbook by name I have to include the extension, unless the workbook hasn't been saved yet.

I realise your reluctance to us ActiveWorkbook and it is possible you could refer to the wrong workbook.

That might be more likely to happen if you have other workbooks open, workbooks being opened/closed in the rest of the code etc.

 

[foolios]

You were right.

Thank you for correcting my error.