VB - Paste in last active cell

[adgjqetuo]

I'm working on this Macro process - and I can't figure two things out.

1) How do I get it to past contents in the second blank cell at the bottom of a list in a specific column? IE - data in B1:B17, paste new list in B19. What I'd REALLY like, is for it to paste in B8, but if B8 used, THEN paste to the second to last blank cell in column B. (if thats even possible)

2) I have VB open an excel workbook, grab data, copy and then past into 1) (above), but then close that workbook. However it always asks "do you wish to save?" and "Do you wish to keep data on clipboard" How can I program it to say "no" for both of these windows prompts?

Here's an excerpt of my code that I need help with:

Please Login or Register  to view this content.

Thanks in advance!!

[antoka05]

Try with this code:

Please Login or Register  to view this content.

Regards,
Antonio

[adgjqetuo]

Thanks for the response!!

I actually solved the first problem with this code (I just forgot to update my post). It seems to work ok so far.

Please Login or Register  to view this content.

I will try the Blue part you suggested today once I get into work - keeping my fingers crossed!

Thanks for the response!

[adgjqetuo]

Worked Great!

Thanks!!