"Typt mismatch" msg

[Mamud]

Hi All,

When I run that code, i have got a msg "type mismatch", I tried to solve it but i cant

please HELP..

Please Login or Register  to view this content.

The error here, in that line

Please Login or Register  to view this content.

[mohd9876]

in what line does the error appear?
could you post a workbook?

[Mamud]

sorry mohd9876, i forget that issue

i edited it in the original post

[mohd9876]

you can't change the value for range with multiple cells, instead you can do the following

Please Login or Register  to view this content.

[royUK]

What's the poin t in using : to join lines like that, it just makes reading the code more difficult.

Also, why set a range to what is almost the whole column, just limit it too the cells used in the column.

[Mamud]

thx mohd9876

it works, but the excel file when running, hang

[mohd9876]

That's because of what RoyUK just said.. you are applying the code to the whole column while you can just limit it to the cells in use like this:

Please Login or Register  to view this content.

[royUK]

That's because of what RoyUK just said.. you are applying the code to the whole column while you can just limit it to the cells in use like this:

Please Login or Register  to view this content.

Well at least someone reads all the posts.

[Mamud]

sorry for delay

I have changed the code to

Please Login or Register  to view this content.

but now, i still have the same error "Type mismatch"
when i select the second option "Swab Test", in that part of code

Please Login or Register  to view this content.

[mohd9876]

well now the type miss match is due to another issue which is because your adding a (most probably) string to a number

Please Login or Register  to view this content.

[Mamud]

it's important to run that line

Please Login or Register  to view this content.

[mohd9876]

what are your trying to accomplish with this line?
what good could it make adding 0 to anything,, if you want to add a 0 to the beginning of a string try this

Please Login or Register  to view this content.

[Mamud]

this zero aims to trun the range (SMax) from text to value

I tried to try ur last code but the numbers in range (SMax) appear with 0

[mohd9876]

why not use

Please Login or Register  to view this content.

[Mamud]

Wow........ thx thx thx

it works