PDA

View Full Version : Solved: Subscript out of range on .Find



YellowLabPro
08-31-2007, 03:16 AM
Set x = Range("G1:G15").Find("Need Parent", LookIn:=xlValue)

is returning subscript 9 out of range.
This is on the activesheet and referred to in this manner.

Bob Phillips
08-31-2007, 03:26 AM
Set x = Range("G1:G15").Find("Need Parent", LookIn:=xlValues)

YellowLabPro
08-31-2007, 04:40 AM
Thanks Bob.....
Darn it. I should have not tripped on that one, but I would not have found it. It is solid in my mind to just be xlValue. I know now though. I even used the recorder, but did not copy only viewed.....