Hi All,
When I run that code, i have got a msg "type mismatch", I tried to solve it but i cant
please HELP..
The error here, in that linePlease Login or Register to view this content.
Please Login or Register to view this content.
Hi All,
When I run that code, i have got a msg "type mismatch", I tried to solve it but i cant
please HELP..
The error here, in that linePlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Mamud; 09-19-2011 at 06:23 AM.
in what line does the error appear?
could you post a workbook?
sorry mohd9876, i forget that issue
i edited it in the original post
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.
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.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
thx mohd9876
it works, but the excel file when running, hang
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.
sorry for delay
I have changed the code to
but now, i still have the same error "Type mismatch"Please Login or Register to view this content.
when i select the second option "Swab Test", in that part of code
Please Login or Register to view this content.
Last edited by Mamud; 09-18-2011 at 11:41 PM.
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.
it's important to run that line
Please Login or Register to view this content.
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.
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
why not use
Please Login or Register to view this content.
Wow........ thx thx thx
it works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks