Find function using variable

[nora1212]

Hi,

I'm trying to use the find function in VBA, but need the "what" to reference a variable rather than the actual search text. In this instance the variable is called "ModuleNo" which contains the name "M123456". VBA doesn't appear to be able to use the variable in this way. Any ideas?

This works:
Range("A1:Z500").Find(What:="M123456", LookIn:=xlValues).Select

This doesn't
Range("A1:Z500").Find(What:=ModuleNo, LookIn:=xlValues).Select

 

[MARK858]

Works fine for me, what are your settings in the Find dialog?

Book1.xlsb
	A	B	C	D	E
1
2
3
4
5
6
7
8
9
10
11				M123456
12
Sheet5

 

[nora1212]

Hi Mark,

Thanks for your help. Rookie mistake. I didn't declare the variable

 

[MARK858]

Hi Mark,

Thanks for your help. Rookie mistake. I didn't declare the variable

Happy you have got it working but omitting the variable shouldn't make a difference (if you declared it wrong it would but not omitting it)

 

[nora1212]

Happy you have got it working but omitting the variable shouldn't make a difference (if you declared it wrong it would but not omitting it)

Yes, you're right....hmmm. It must have been a typo on my part and/or the number wasn't found. Thanks anyway though.

 

[MARK858]

You're welcome