Run Time Error

[mlinek]

I have been trying to run a macro at work. I'm not particularly talented with writing code, but the error seems to happen when I use new computers. The place where the code fails is on this line:

Sheets("Capture").Select

As I understand it, all this is doing is selecting the sheet called Capture, which exists and is made visible through another line of code.

The problem may be caused by switching from excel 2010 to excel 2016, as I am running a similar macro with slightly different inputs on another computer right now using 2010, and it seems to be working. Once it is complete I will try and run it the excel 2010 computer.

There was another error related to the switch which I believe I have solved related to the references. I had a missing reference. Not sure if that is the root of the issue.

The error I am receiving is 1004 runtime. It's as if it thinks the sheet doesn't exist.

[alansidman]

In the Sheet "Capture" are there any leading or trailing spaces. That would cause this type of error. Likewise, if there are none in the sheet, but in your code.

[davesexcel]

You haven't supplied the code to test it.

[alansidman]

Hey Dave,
You probably did not notice that this is a thread from 2017. Would be surprised if the OP ever checks back in.

Alan