Run time Error 438

[amirdifraxe]

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

23403

[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

[大灰狼1976]

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.

[amirdifraxe]

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 .

[amirdifraxe]

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