Finding specific text and pasting clipboard relative to it

[chadski778]

I would like to paste the contents of the clipboard into column A of my active worksheet on the same row as the text "Actual%". This text is not duplicated anywhere else in my spreadsheet but its position varies

Thank you

 

[p45cal]

ActiveSheet.Paste Cells.Find("Actual%").Offset(, 1) ' to the right

 

[pgc01]

Similar to p45cal's:

Cells.Find("Actual%").Offset(, 1).PasteSpecial  ' to the right

 

[chadski778]

Thanks, that works when I have text copied to the clipboard but not if I have the contents of a group of cells copied. I would like a selection of cells copied into that position

 

[pgc01]

I would like to paste the contents of the clipboard into

This was what you asked. To paste the contents of the clipboard.

I would like a selection of cells copied into that position I would like a selection of cells copied into that position

This is another thing. Not enough details, but you may adapt, for ex.:

Range("A1:D1").Copy Destination:=Cells.Find("Actual%")

 

[chadski778]

This has worked thanks. I edited it to enable me to copy from a separate spreadsheet and paste into my active worksheet relative to my specific text

Thank you

 

[pgc01]

I'm glad it helped!