Having trouble using clipboard data in Find function

[RollerRagerMD]

When I execute this code, I get this error: Runtime Error 438, Object doesn't support this property or method

Please Login or Register  to view this content.

Basically, what I'm trying to do is grab the value of the first cell of the last row in Sheet1, then find the cell with that value in Sheet2. I put a breakpoint in "MyData.GetFromClipboard" and the code seems to crash in the Cells.Find block. I copied that block from a macro I recorded where I manually opened the Find function and looked for a value, then just replaced the value in the macro with the name of the DataObject variable.

[Leith Ross]

Hello RollerRagerMD,

Welcome to the Forum!

I am not sure why you want to use the data object to simply transfer text from one cell to another. You can make the assignment directly from one cell to the other.

[RollerRagerMD]

Thanks for the welcome!

I admit that I'm not sure why I'm using it either. I did some Google searches and that was one of the solutions posted on another website for someone with a similar objective. If there's an easier way to do it, I'd appreciate it if you'd show me how. I'm a complete novice when it comes to VBA (I took a semester of Visual Basic but this is a whole 'nother ballgame!).

[Leith Ross]

Hello RollerRagerMD,

Sorry about the delay, I had to feed my dog and give her medicine. If you don't need to copy the cell formatting then you can transfer the text this way...

Please Login or Register  to view this content.

EDIT NOTE: Forgot to add the "SET" statement before LastCell.