finding copied text

[Luis939]

i'm trying to copy a cell's content from one file and using the Find method (ctrl+F) in another. Until now I had pasted that text in the other file and them said
.find(what:=activecell...
but is there a way to not have to paste that text, just say search for what is in the clipboard, perhaps set that text to a variable and do a find for that variable, thanks!

 

[xlbo]

Presumably you are doing the copy from a selection or range definition - something like selection.copy or range("A1&quot.copy

Instead of that, use
fWhat = selection.text
or
fWhat =range("A1&quot.text

Then use
With sheets("Sheet2&quot.columns(1)
set fCell = .find(fWhat, lookin:=xlvalues)
if not fCell is nothing then
'Found
else
'Not Found
end if
end with Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde