View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
S G Booth S G Booth is offline
external usenet poster
 
Posts: 20
Default 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.