VBA to paste clipboard data to next available row

[AGrayson84]

Good afternoon/morning/evening everyone! I was hoping someone wouldn't mind helping me with a little code I've had trouble trying to find a working version of on the various forums and articles out there.

I have a Macro that pastes clipboard data specifically to cell A9 on the current worksheet.

The starting cell of each row that the data will be pasted in is column "A". Starting with row 9 (ignoring any rows above), I would like the VBA to check for data in column "O". If cell "O9" contains data, I would like the script to paste clipboard data in the next row ("A10"). The next time I run the macro, if something is in O21, I would like the clipboard data to be pasted starting in cell A22, for example.

Thanks a bunch to anyone that is willing to help... I really appreciate it!


Best Regards,
Andrew

 

[Fluff]

Hoe about

Sub t()
Range("A" & Range("O" & Rows.Count).End(xlUp).Offset(1).Row).PasteSpecial
End Sub

 

[AGrayson84]

Hoe about

Sub t()
Range("A" & Range("O" & Rows.Count).End(xlUp).Offset(1).Row).PasteSpecial
End Sub

Thanks so much Fluff I really appreciate that! I don't have Excel on the laptop I'm replying from right now, but will that know to ignore rows above 9? I do have some rows above row 9 that don't have anything in column O that I would like to omit from the scope. Anything row 9 and below is what I want to concentrate on. Thanks again Fluff!!!!!!!!!!!!!!!!!!!!

 

[Fluff]

As long as you have data in O9 or below, then it will work