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.....
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.