Hi,

I'm trying to use the .find() function. It works fine when I look for something which I have manually entered, for example
myWorkSheet.rows(4).find(what:=WhatImLookingFor)
works fine.

But when what i'm looking for is not entered manually, i.e. it is a cell with a formula I can't seem to use the .find() function to find it. How can I make that work?

I hope my question makes sense, I realize it may be a bit vague.
Thanks for any help!