Using Copied Cell Value in Find

[norts55]

Hello,
Can someone tell me how to use the find function using the value that has been copied to the clipboard?

I have a simple code below. After I select column AA of Sheet Cost Codes, I need to jump into the find and use the value that I copied from cell C2.

Thanks in advance

Sub Macro5()
'
' Macro5 Macro
'

'
    Sheets("Imported Bid List").Select
    Range("C2").Select
    Selection.Copy
    Sheets("Cost Codes").Select
    Columns("A:A").Select
End Sub

 

[SQUIDD]

Your whole macro could be written like.

Sub Macro5()
    a = Range("'Imported Bid List'!c2")
    'now do what you want with a using find etc
End Sub

no need to access the clipboard