How to trim a character from a cell ?
Hi, I have a macro that compares two numbers from when i scan a
quantity on a part number. And if the first cell is greater than the
second cell, the first cell should highlight a color, which is working
with no problems. But the problem is that everytime I scan a part
number the amount always begins with a "Q" example:Q000003. And it will
always give me the wrong results. The cell will still highlight even
though the first cell is less than the second cell, because of the "Q".
I know this because I've tried putting two numbers without the Q
manually and I always get the right results. Basically, I don't know
the syntax to use the trim method or mid method in vb6. I just need a
method to remove the character "Q" but not the numbers. And would I put
this syntax in my module where I have my macro?
Thanks.
|