Looking up a variable using the Find function

[Steve0492]

Hello,

I am attempting to use the Find function in VBA to look up the row number of a variable. Here is my code:

Please Login or Register  to view this content.

SpecTwnRng is a string containing numbers and letters. It is contained in column A within Sheets(sht). I think I just have improper syntax. Thanks for the help!

Steve

[tigeravatar]

Steve,

Your code looks good. What happens if, after that snippet, you do this?

Please Login or Register  to view this content.

[Steve0492]

It was a faulty reference on my part.. thanks for the reply tiger.