I have a macro that has hit a snag. On one of the pages of the workbook, I
have a list of product codes. Some are copied over and sort fine. Others, the
same codes, are copied with a leading space or a " ' " before the code. Is
there an If then statement I can use that will remove any leading spaces or
this symbol? It's messing up a sort that the entire macro depends on. Not all
of the product codes have these spaces or characters which is why I need an
if then statement to do nothing if they aren't there and to remove them if
they are. Thanks in advance for any help you can offer.
--
A Waller