Conditional Ranges?

ToddM · Mar 15th, 2002, 07:39 AM

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 · Mar 15th, 2002, 08:35 AM

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 · Mar 15th, 2002, 09:05 AM

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

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 07:39 AM	#1
ToddM New Member Join Date: Feb 2002 Posts: 6	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")

Mar 15th, 2002, 08:35 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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.