Run time error 13 type mismatch excel vba

[E5254730]

Hello,

I'm using below code to auto update data from one sheet to another within same workbook :

Please Login or Register  to view this content.

"C2" is the cell in which I enter the Project No. and the data is automatically updated.

But for some of the project No. the data is not getting updated, even though we have the data for that projects. Say for example, if I enter project no. 32, the data gets updated, if I'm entering 925, 938 project no. in "C2" cell, I'm getting "Run time error 13 type mismatch" error message.

Please suggest. Thanks !

[sintek]

Where is your sample file?

[E5254730]

Hi Sintek,

Please refer to a sample file.

Coding is slightly different from the one that I posted in my first thread.

[sintek]

Update to...

Please Login or Register  to view this content.

[rorya]

Specify the Value property:

Please Login or Register  to view this content.

[E5254730]

Hey Sintek and Rory,

Thanks ! this helped to fix the error.

[sintek]

Glad we could assist...Tx for rep +