Pasting into the next blank cell in a column, rather than specific cell.

[mackinlay]

Hi everone,

I was wondering if anyone could help me with a problem I'm having...

I am trying to write some code so that I can paste a selection of text (B4:B11on sheet1) into cell the first blank cell in column B on sheet2, rather than specifying exactly which cell it is posted into.

If anyone could shed some light onto this problem I would be extremely grateful!

Thanks,
Alex

[StephenR]

Alex - like so perhaps:

Please Login or Register  to view this content.