Copy a column and paste to a different column in a different sheet

[smartbuyer]

I tried using the code below to export from another sheet to a different column in a another sheet and getting an error:

my full code is: (the red code lines will be the ones I am getting the error from)

Please Login or Register  to view this content.

[JLGWhiz]

What is the error message? and which specific line is highlighted when you click debug?

[smartbuyer]

I will be getting an image of the error and post as soon as possible

[smartbuyer]

here are the images of the error
Capture2.PNGCapture1.PNG

[JLGWhiz]

The images did not come through, but maybe this will help. In this:

Set found = wsProc.Columns(1).Find(cel, lookat:=xlWhole)

line of code, change to

Please Login or Register  to view this content.

[smartbuyer]

tried to attached the images to a spreadsheet. see errors.xlsx

[smartbuyer]

t

The images did not come through, but maybe this will help. In this:

line of code, change to

Please Login or Register  to view this content.

tried updating the line of code as above, still getting the error.

[JLGWhiz]

tried to attached the images to a spreadsheet. see Attachment 441209

Since every variable in that line had previously been used without error, you need to use your mouse pointer while in debug mode and hover over each variable to see which one lost its value. The defective variable should show "Nothing" as a value in the tool tips box while the mouse pointer hovers over it. Just looking at the code, I cannot readily see any reason for an error, but sometimes blank cells in a column or row can cause a change in a variable value. This is especially true with a Find statement. Since you are using the find statement while in filter mode, it could be that a found cell is not visible and is causing the problem. But that is just a guess.

[smartbuyer]

Since every variable in that line had previously been used without error, you need to use your mouse pointer while in debug mode and hover over each variable to see which one lost its value. The defective variable should show "Nothing" as a value in the tool tips box while the mouse pointer hovers over it. Just looking at the code, I cannot readily see any reason for an error, but sometimes blank cells in a column or row can cause a change in a variable value. This is especially true with a Find statement. Since you are using the find statement while in filter mode, it could be that a found cell is not visible and is causing the problem. But that is just a guess.

I will look into it, there might be a need for me to change the entire code to import from a specific column of one file to a specific column on another based on criteria.

Appreciate you looking into this JLGWhiz.

[JLGWhiz]

I will look into it, there might be a need for me to change the entire code to import from a specific column of one file to a specific column on another based on criteria.

Appreciate you looking into this JLGWhiz.

Glad to assist, hope you find the problem.
Regards, JLG