Copying row from a range to another file/Run time error 13-Type mismatch

[Shanghai3]

Dear Users,

I have problem with the following row in my macro:
Does anyone know what can be the problem?
Thank you for your help in advance.

Regards,

Shanghai3

omszrange.Rows(rownum).Copy Workbooks(Filename2.Cells(i, 1)).Worksheets(Tabname3.Cells(i, 1)).finishrange

 

[Shanghai3]

Dear Joe4,

I really thank you, that you are trying to help me.

I have tried what you proposed and I checked the cursor above the variables and Filename2 variable has the right value, Tabname3 also has the right value, but
there some problem occurs by pasting to Range C63. I still do not know what is the problem.

Workbooks(Filename2.Cells(i, 1)).Worksheets(Tabname3.Cells(i, 1)).Range("C63").PasteSpecial Paste:=xlPasteValues

The error message is: Run time error 13-Type mismatch.

Possibly I am dummy, but I really do not know what is the problem.

Regards,

Shanghai3

 

[johnnyL]

@Shanghai3 what happens if you replace:

omszrange.Rows(rownum).Copy
            Workbooks(Filename2.Cells(i, 1)).Worksheets(Tabname3.Cells(i, 1)).Range("C63").PasteSpecial Paste:=xlPasteValues

with:

omszrange.Copy
            Workbooks(Filename2.Cells(i, 1)).Worksheets(Tabname3.Cells(i, 1)).Range("C63").PasteSpecial Paste:=xlPasteValues

 

[Joe4]

Dear Joe4,

I really thank you, that you are trying to help me.

I have tried what you proposed and I checked the cursor above the variables and Filename2 variable has the right value, Tabname3 also has the right value, but
there some problem occurs by pasting to Range C63. I still do not know what is the problem.

Workbooks(Filename2.Cells(i, 1)).Worksheets(Tabname3.Cells(i, 1)).Range("C63").PasteSpecial Paste:=xlPasteValues

The error message is: Run time error 13-Type mismatch.

Possibly I am dummy, but I really do not know what is the problem.

Regards,

Shanghai3

You did not do what I suggested at all. Get rid of ALL your variables, and replace them with hard-coded values.
The first step is to get it working using ALL hard-codes values. This will ensure that you have the structure correct.
Once you have that working, then you can start replacing the hard-coded values with variables, one at a time.

I am trying to teach you a method on how to figure out these sort of things for yourself.
Start with a simple example (hard-coded) of what you want to do, and work up from there.