Why not just load a string with that value, and check if the first char is a
', if so replace it. Then just carry on as before.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JT" wrote in message
...
I have a macro that performs an edit on the the length of
cell. If it is more than 4 characters, it provides an
error message and stops the macro so the user can fix the
problem.

One user has entered data that is confusing. The cell is
displayed as '0599 on the toolbar. In the cell it looks
like 0599.

Another macro uses looks at the cell and takes the first 2
characters '5 and put it in a column. The macro then
takes the next 2 characters 09 and puts it in a second
column. This causes an error because we are looking for
05 and 99.

When I check the length of the variable with '0599, it is
4. I'n not sure how to work with this data. How do I
handle the tick mark (') in the first macro?

Any suggestions would be appreciated. Thanks for the help.

I must be missing something because the variables do not
show the tick mark ('). The only place that I see the
tick mark is on the toolbar.

Some of the cells Im looking at are all numeric and some
are alpha numeric combinations.


-----Original Message-----
Why not just load a string with that value, and check if
the first char is a
', if so replace it. Then just carry on as before.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JT" wrote in
message
...
I have a macro that performs an edit on the the length
of
cell. If it is more than 4 characters, it provides an
error message and stops the macro so the user can fix
the
problem.

One user has entered data that is confusing. The cell
is
displayed as '0599 on the toolbar. In the cell it looks
like 0599.

Another macro uses looks at the cell and takes the
first 2
characters '5 and put it in a column. The macro then
takes the next 2 characters 09 and puts it in a second
column. This causes an error because we are looking for
05 and 99.

When I check the length of the variable with '0599, it
is
4. I'n not sure how to work with this data. How do I
handle the tick mark (') in the first macro?

Any suggestions would be appreciated. Thanks for the
help.


.