Is this macro scenario possible using VBA?
 

Mark,

Your contributions have helped me tremendously. Would you send me your
email address so that I can send you a small token of appreciation?
Please send it to thewordfortheuniverse at gmail dot com.

This macro does exactly what I need, though I accidentally wrote
A1
A2
A3
... etc (column)

but meant to write
A1
B1
C1
... etc (row)

Could you let me know what piece of code I need to edit so that it spits
out the data across the row?

Please do send me your email address. I'd really like to thank you for
your immense help.

All the best,

Kelly




*** Sent via Developersdex http://www.developersdex.com ***