iloc = Instr(FirstPageNumber,"/")
if iloc < 0 then
firstNum = clng(left(FirstPageNumber,iloc-1))
Else
firstNum = clng(FirstPageNumber)
End if


--
Regards,
Tom Ogilvy

"S G Booth" wrote in message
...
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.