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")
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")