View Full Version : Run time Error 438
amirdifraxe
12-13-2018, 07:33 AM
Hello Dears , i Write this code and i get this error . could you please to help me . thank you
23403
Stohan
12-13-2018, 04:18 PM
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
12-13-2018, 06:52 PM
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
12-14-2018, 01:00 AM
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
12-14-2018, 01:01 AM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.