Scope ("a; A ") can't write like this. There seems to be a semicolon in the middle. I have only seen the way of columns ("A:A").

If the first line is the title line, it should be written as follows:

iMaxRow？ =? Shh. Scope ("A65535"). End (xlUp). row

Settings? Rng？ =? Shh. Range("A2:A "？ & amp？ iMaxRow)。 Find (ComboBox 1. Value? ,? ,? XL overall)