copy paste and print

Hi everybody! i'm newbe with visual basic..and i have a question:

in column A there is a list of names, i'm trying to create a cile that will copy and paste these names (one at time) in a specific cell and then print it..

does anybody know how to help me?




Please post Excel questions, in the Excel forum.

Thank you.

Hi teocomi and welcome to the forum! :)

Please be sure to read the posting guidelines (http://www.xtremevbtalk.com/faq.php?faq=evbf_faq#faq_evbf_rules).

I'm sure we can help you with this. I guess you're using VBA?

When you're starting out, a good way to generate code is to use the macro recorder. Have a go with it and take a look at the code it produces. Once you have that code, post back with it and then we can have a look at how it could be tailored to meet your needs.

Colin

This is how I had started out. Just as Colin said. After you record a macro in Excel go to Macro menu and find the macro you just made and click "Step into". It will open your macro code in VB. :)