Conditional Ranges?

[ToddM]

I have a text file that I am imorting into a spreadsheet.

Dim Plate As Integer
Plate = Range("C1")

Occasionally the value I'm looking for ends up 2 columns to the left.
If this happens how can I apply a conditional statement that resets the range to("A1")

 

[Al Chara]

If when this happens, there is nothing in C1 then use the following code:
Dim Plate As Integer
If Range("c1").Value = "" Then
Plate = Range("a1").Value
Else: Plate = Range("c1")
End If

Hope this helps.
Kind regards, Al.

 

[ToddM]

Al,
It works like a charm. Thanks so much for your help, it pulled me from a sticky situation.
Thanks Again
ToddM

On 2002-03-15 07:35, Al Chara wrote:
If when this happens, there is nothing in C1 then use the following code:
Dim Plate As Integer
If Range("c1").Value = "" Then
Plate = Range("a1").Value
Else: Plate = Range("c1")
End If

Hope this helps.
Kind regards, Al.