Having trouble defining .FIND Range

[WinterStorm]

Greetings,

I have a sub I have been working on for a while. It works beautifully on the first section of my spreadsheet, but not on any subsequent sections.

I am working with an antiquated report our accounting system spits out.

I need to look for the first instance of a value, ("STATE END") in column A, starting at the row I have defined with my input box ("CurrRow") and searching to the bottom of the worksheet.

The line that is not working for me is "Set uRange = Activesheet.UsedRange"
Everything else works great.

Here is what I have:

Please Login or Register  to view this content.

Please help!!!

[xladept]

Have you defined your variable?

Please Login or Register  to view this content.