Run time Error 438

Hello Dears , i Write this code and i get this error . could you please to help me . thank you

Attachment 23403

Hello there

Is it VB code, which you are using in VBA excel

So the thing is Print isn't statement which you can use, you can tryout Cells(1, 1).Value for example.
May be some other issues will come up, because of VB code. Need to check and not to retype everything.

All the best

Attachment 23407
you have to change (Print 1, "sk="; sk; "sp="; sp) to (debug.Print 1, "sk="; sk; "sp="; sp).
then the result will be displayed at the immediate window like my posted picture.

Quote:

---

Originally Posted by Stohan

Hello there

Is it VB code, which you are using in VBA excel

So the thing is Print isn't statement which you can use, you can tryout Cells(1, 1).Value for example.
May be some other issues will come up, because of VB code. Need to check and not to retype everything.

All the best

---

Thank You Sir .

Quote:

---

Originally Posted by 大灰狼1976

Attachment 23407
you have to change (Print 1, "sk="; sk; "sp="; sp) to (debug.Print 1, "sk="; sk; "sp="; sp).
then the result will be displayed at the immediate window like my posted picture.

---

Thank You Sir i will test it . Thanks a lot again
Best Regards