Hi,

I'm trying to write a program using a spreadsheet that has two columns for
the telephone number: the first is the actual telephone number, but in some
cases it refers to the data circuit and the actual tel no is in the second
column. I can tell if the tel no is a circuit by the number being AREA CODE
and then a 1, followed by 6 digits (for example, 4161334444). I need to
figure out how to use the second column of telephone numbers when this
happens (which is only about 3% of the time, but these are critical to my
business). But for some reason, I cannot figure out what data type i need to
use (I've tried string, variant, and integer) all to no avail...
Right now, the code looks like this (feel free to laugh, i've been working
on this for about 35 hours since Thursday morning and am a wee bit fried)...

Dim Telno As String
Dim Auxno As String

If Range("Telno") = "5191*" Then
Range("Auxno").Copy
Range("Telno").Paste
End If

End Sub

I would appreciate any help as soon as possible.....I need this program up
and running by tomorrow afternoon...groan...
Chris