Hi guys
---a ---b---c---d---e---f
1 100 200 300 400 500 600
This works
Sub testmyrange()
mystart = Range("a1:f1").Find(100).Column
End Sub
This does not
Sub testmyrange()
mystart = Range("a1:f1").Find(500).Column
End Sub
I would be most appreciative if someone could enlighten me as to what I am doing wrong.
Regards
Brad
---a ---b---c---d---e---f
1 100 200 300 400 500 600
This works
Sub testmyrange()
mystart = Range("a1:f1").Find(100).Column
End Sub
This does not
Sub testmyrange()
mystart = Range("a1:f1").Find(500).Column
End Sub
I would be most appreciative if someone could enlighten me as to what I am doing wrong.
Regards
Brad