Split question in XL2003
I would like to test a cell's value to see if it takes the form
?/? where ? should simply be integers.....something like
2/1 or 27/1 or 256/1
The requirement is for the value to be in the form
integer/1
I have: varr = Split(FirstPageNumber, "/")
where FirstPageNumber holds the value of the cell in
question (as a String). This works (sort of) but not in all
cases (eg when "/" is missing).
I need to do this test just once for each sheet, and wish
to get the integer value.
Would appreciate some help, please.
Regards.
|