Quote Originally Posted by mdmackillop
Option Explicit forces you to declare variables. Typos etc. will be identified when you try to run the code.
r is working fine. Its rprev and cprev that I cant get to work.

I just tried this, and its not working either.

[VBA]rprev = Worksheets("FloorPlan").Columns("F").Find(Worksheets("datatest").Cells(rcom pr, ccompr).Value).Row[/VBA]

So I am baffled. Oh yeah, and "Cell" works just fine without the ".value" part.

Does the find item need ot be an object, or can it be an expression or a reference? What's the criteria?

Thanks

SRM