Subscript Out of Range (Error) when running a macro

Hello Everybody,
Can somebody please help me with the following error. I have macro that is checking column F for a user's name and then transferring the data found in that row to the corresponding Sheet with that name. So if the user's name is Tim it will look for the Sheet with that exact name and transfer the information to that file. This macro works fine with my test data when I just typed in the information but when I tried to copy and paste the data into the cells and then run the macro I get the Subscript Out of Range(error) Can someone please help me on what is going on.Capture.PNG

Perhaps one of the names in Column F doesn't have a Sheet named after it?

I can see that on the backend its numeric but It's just confusing me because it works fine when I type the information in. But if I try to copy and paste the data from another file it comes up with the error. This is the coding I have running in other portions of the overall macro.

Please Login or Register  to view this content.

As you can see I'm calling the Sheets by Sheet1 and Sheet2.

Originally Posted by Norie

If the value in the cell is numeric then when you use Sheets(c.Value) VBA will regard c.Value as the Index of the sheet, not the name.

To use the value as the name of the sheet use CStr, Sheets(CStr(c.Value)).

Hey Norie,

Appreciate your response. Is there a way you can send me what my coding should look like with your coding so I don't screw it up and cause myself more problems. I appreciate your help.